Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Headcount Plan

people analytics dashboard

Headcount Plan

Plan-versus-actual headcount, hiring, exits, cost, and scenario measures.

6 pages · Power BI

These dashboards use synthetic workforce data. Values illustrate the report design.

Choose page — 4 Cost vs plan

Selected page

4 Cost vs plan

DAX definitions

Exact source expressions and direct measure dependencies for the selected page.

Actual Cost

HcPlan · Cost

SUM(HcPlan[actualCostUsd])

Direct dependencies: None

Cost Variance

HcPlan · Cost

IF(ISBLANK([Actual Cost]), BLANK(), [Actual Cost] - [Planned Cost (Actual Months)])

Direct dependencies: Actual Cost, Planned Cost (Actual Months)

Cost Variance %

HcPlan · Cost

DIVIDE([Cost Variance], [Planned Cost (Actual Months)])

Direct dependencies: Cost Variance, Planned Cost (Actual Months)

Planned Cost (Actual Months)

HcPlan · Cost

CALCULATE(SUM(HcPlan[plannedCostUsd]), KEEPFILTERS(HcPlan[phase] = "Actual"))

Direct dependencies: None