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 — 10 Promotion and office attendance

Selected page

10 Promotion and office attendance

DAX definitions

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

% At Full Compliance

PerfEmployee · Promotion & Pay

DIVIDE(CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[hybridCompliance] >= 1)), CALCULATE(COUNT(PerfEmployee[hybridCompliance]), KEEPFILTERS(PerfEmployee[status] = "Active")))

Direct dependencies: None

% 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

Average Hybrid Compliance

PerfEmployee · Promotion & Pay

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

Direct dependencies: None

Average Hybrid Compliance (n>5)

NineBox · Cycle Trend

IF([Hybrid Tracked Employees] > 5, [Average Hybrid Compliance], BLANK())

Direct dependencies: Hybrid Tracked Employees, Average Hybrid Compliance

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

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

Promotion Rate

PerfEmployee · Promotion & Pay

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

Direct dependencies: Recent Promotions, Headcount (As Of)

Promotion Rate (n>5)

NineBox · Cycle Trend

IF([Headcount (As Of)] > 5, [Promotion Rate], BLANK())

Direct dependencies: Headcount (As Of), Promotion Rate

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