Actual Cost
HcPlan · Cost
SUM(HcPlan[actualCostUsd])Direct dependencies: None
people analytics dashboard
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.
Selected page
Exact source expressions and direct measure dependencies for the selected page.
HcPlan · Cost
SUM(HcPlan[actualCostUsd])Direct dependencies: None
HcPlan · Cost
IF(ISBLANK([Actual Cost]), BLANK(), [Actual Cost] - [Planned Cost (Actual Months)])Direct dependencies: Actual Cost, Planned Cost (Actual Months)
HcPlan · Cost
DIVIDE([Cost Variance], [Planned Cost (Actual Months)])Direct dependencies: Cost Variance, Planned Cost (Actual Months)
HcPlan · Cost
CALCULATE(SUM(HcPlan[plannedCostUsd]), KEEPFILTERS(HcPlan[phase] = "Actual"))Direct dependencies: None