Performance Calibration

Calibration, trajectory, equity screening, talent, readiness, and development views.

19 pages · Power BI

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

Choose page — 8 Pay position vs rating (9-box)

Selected page

8 Pay position vs rating (9-box)

DAX definitions

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

Headcount (As Of)

PerfEmployee · Flow & Attrition

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"))

Direct dependencies: None

Pay Risk Text

NineBox · Report Views

IF([Headcount (As Of)] = 0, BLANK(), "Rated 4–5 and paid below 0.90 of range midpoint: " & FORMAT([Rated 4–5 Paid Below 0.90 (Before Cycle)] + 0, "#,0") & " before the cycle, " & FORMAT([Rated 4–5 Paid Below 0.90 (After Cycle)] + 0, "#,0") & " after. Rated 1–2 and paid above 1.10: " & FORMAT([Rated 1–2 Paid Above 1.10 (Before Cycle)] + 0, "#,0") & " before, " & FORMAT([Rated 1–2 Paid Above 1.10 (After Cycle)] + 0, "#,0") & " after.")

Direct dependencies: Headcount (As Of), Rated 4–5 Paid Below 0.90 (Before Cycle), Rated 4–5 Paid Below 0.90 (After Cycle), Rated 1–2 Paid Above 1.10 (Before Cycle), Rated 1–2 Paid Above 1.10 (After Cycle)

Rated 1–2 Paid Above 1.10 (After Cycle)

PerfEmployee · Promotion & Pay

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBand] = "Low (1-2)"), KEEPFILTERS(PerfEmployee[payBandPost] = "High (>1.10)"))

Direct dependencies: None

Rated 1–2 Paid Above 1.10 (Before Cycle)

PerfEmployee · Promotion & Pay

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBandPre] = "Low (1-2)"), KEEPFILTERS(PerfEmployee[payBand] = "High (>1.10)"))

Direct dependencies: None

Rated 4–5 Paid Below 0.90 (After Cycle)

PerfEmployee · Promotion & Pay

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBand] = "High (4-5)"), KEEPFILTERS(PerfEmployee[payBandPost] = "Low (<0.90)"))

Direct dependencies: None

Rated 4–5 Paid Below 0.90 (Before Cycle)

PerfEmployee · Promotion & Pay

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBandPre] = "High (4-5)"), KEEPFILTERS(PerfEmployee[payBand] = "Low (<0.90)"))

Direct dependencies: None