// Project Controls Performance Lab — illustrative DAX measures

Planned Progress % :=
DIVIDE(
    SUMX(FactProjectControl, FactProjectControl[planned_progress_pct] * RELATED(DimActivity[planned_total_resource_hours])),
    SUM(DimActivity[planned_total_resource_hours])
)

Actual Progress % :=
DIVIDE(
    SUMX(FactProjectControl, FactProjectControl[actual_progress_pct] * RELATED(DimActivity[planned_total_resource_hours])),
    SUM(DimActivity[planned_total_resource_hours])
)

Schedule Variance pp :=
[Actual Progress %] - [Planned Progress %]

Negative Float Activities :=
CALCULATE(
    DISTINCTCOUNT(FactProjectControl[activity_id]),
    FactProjectControl[total_float_days] < 0
)

Near Critical Activities :=
CALCULATE(
    DISTINCTCOUNT(FactProjectControl[activity_id]),
    FactProjectControl[total_float_days] <= 5
)

Resource Variance Hours :=
SUM(FactProjectControl[actual_hours_to_date])
- SUM(FactProjectControl[planned_hours_to_date])

Late Milestones :=
CALCULATE(
    DISTINCTCOUNT(FactProjectControl[activity_id]),
    FactProjectControl[milestone_flag] = TRUE(),
    FactProjectControl[forecast_finish] > FactProjectControl[baseline_finish]
)