Choose dashboard — Performance Calibration

people analytics dashboard

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 — 6 Leader scorecard

Selected page

6 Leader scorecard

DAX definitions

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

% Below Hybrid Threshold

PerfEmployee · Promotion & Pay

DIVIDE(CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[hybridCompliance]) && PerfEmployee[hybridCompliance] < 0.8)), [Hybrid Tracked Employees])

Direct dependencies: Hybrid Tracked Employees

% High Performers

PerfEmployee · Rating

DIVIDE([Count High Performers], [Rated Employees])

Direct dependencies: Count High Performers, Rated Employees

% Low Performers

PerfEmployee · Rating

DIVIDE([Count Low Performers], [Rated Employees])

Direct dependencies: Count Low Performers, Rated Employees

% Moved Down

PerfEmployee · Calibration

DIVIDE([Moved Down in Calibration], [Calibrated Employees])

Direct dependencies: Moved Down in Calibration, Calibrated Employees

Average Rating

PerfEmployee · Rating

DIVIDE(CALCULATE(SUM(PerfEmployee[mostCurrentScore]), KEEPFILTERS(PerfEmployee[status] = "Active")), [Rated Employees])

Direct dependencies: Rated Employees

Average Rating (n>=5)

PerfEmployee · Rating

IF([Rated Employees] >= 5, [Average Rating], BLANK())

Direct dependencies: Rated Employees, Average Rating

Calibrated Employees

PerfEmployee · Calibration

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy26ManagerScore]) && NOT ISBLANK(PerfEmployee[fy26CalibratedScore])))

Direct dependencies: None

Count High Performers

PerfEmployee · Rating

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

Direct dependencies: None

Count Low Performers

PerfEmployee · Rating

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

Direct dependencies: None

Exit Rate (Window Population)

PerfEmployee · Flow & Attrition

DIVIDE([Exits (TTM)], [Population in Window])

Direct dependencies: Exits (TTM), Population in Window

Exits (TTM)

PerfEmployee · Flow & Attrition

VAR __AsOf = CALCULATE(MAX(AsOf[asOfDate]), ALL(AsOf)) VAR __Start = EDATE(__AsOf, -12) RETURN CALCULATE(COUNTROWS(PerfEmployee), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[terminationDate]) && PerfEmployee[terminationDate] > __Start && PerfEmployee[terminationDate] <= __AsOf))

Direct dependencies: None

Headcount (As Of)

PerfEmployee · Flow & Attrition

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

Direct dependencies: None

Hybrid Tracked Employees

PerfEmployee · Promotion & Pay

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[hybridCompliance])))

Direct dependencies: None

Manager Quality Index (team-weighted)

PerfEmployee · Leaders

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

Direct dependencies: None

Moved Down in Calibration

PerfEmployee · Calibration

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy26ManagerScore]) && NOT ISBLANK(PerfEmployee[fy26CalibratedScore]) && PerfEmployee[fy26CalibratedScore] < PerfEmployee[fy26ManagerScore]))

Direct dependencies: None

Net Headcount Change %

PerfEmployee · Flow & Attrition

DIVIDE([Headcount (As Of)], [Start Headcount]) - 1

Direct dependencies: Headcount (As Of), Start Headcount

Population in Window

PerfEmployee · Flow & Attrition

VAR __AsOf = CALCULATE(MAX(AsOf[asOfDate]), ALL(AsOf)) VAR __Start = EDATE(__AsOf, -12) RETURN CALCULATE(COUNTROWS(PerfEmployee), FILTER(PerfEmployee, PerfEmployee[hireDate] <= __AsOf && (ISBLANK(PerfEmployee[terminationDate]) || PerfEmployee[terminationDate] > __Start)))

Direct dependencies: None

Rated 4–5 Paid Below 0.90

PerfEmployee · Promotion & Pay

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

Direct dependencies: None

Rated Employees

PerfEmployee · Rating

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

Direct dependencies: None

Start Headcount

PerfEmployee · Flow & Attrition

VAR __AsOf = CALCULATE(MAX(AsOf[asOfDate]), ALL(AsOf)) VAR __Start = EDATE(__AsOf, -12) RETURN CALCULATE(COUNTROWS(PerfEmployee), FILTER(PerfEmployee, PerfEmployee[hireDate] <= __Start && (ISBLANK(PerfEmployee[terminationDate]) || PerfEmployee[terminationDate] > __Start)))

Direct dependencies: None