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 — 12 Equity descriptives

Selected page

12 Equity descriptives

DAX definitions

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

% High Performers

PerfEmployee · Rating

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

Direct dependencies: Count High Performers, Rated Employees

Average Compa-Ratio

PerfEmployee · Promotion & Pay

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

Direct dependencies: None

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

Count High Performers

PerfEmployee · Rating

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

Direct dependencies: None

Headcount (As Of)

PerfEmployee · Flow & Attrition

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

Direct dependencies: None

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

Promotion Rate

PerfEmployee · Promotion & Pay

DIVIDE([Recent Promotions], [Headcount (As Of)])

Direct dependencies: Recent Promotions, Headcount (As Of)

Rated Employees

PerfEmployee · Rating

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

Direct dependencies: None

Recent Promotions

PerfEmployee · Promotion & Pay

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

Direct dependencies: None

Voluntary Exit Rate (Window Population)

PerfEmployee · Flow & Attrition

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

Direct dependencies: Voluntary Exits (TTM), Population in Window

Voluntary 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 && PerfEmployee[terminationType] = "Voluntary"))

Direct dependencies: None