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 — 5 Trajectory

Selected page

5 Trajectory

DAX definitions

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

% Declined (YoY)

PerfEmployee · Trajectory

DIVIDE([Declined (YoY)], [Trajectory Eligible])

Direct dependencies: Declined (YoY), Trajectory Eligible

% Flatlined (YoY)

PerfEmployee · Trajectory

DIVIDE([Flatlined (YoY)], [Trajectory Eligible])

Direct dependencies: Flatlined (YoY), Trajectory Eligible

% Improved (YoY)

PerfEmployee · Trajectory

DIVIDE([Improved (YoY)], [Trajectory Eligible])

Direct dependencies: Improved (YoY), Trajectory Eligible

Average Rating (FY24 Annual)

NineBox · Cycle Trend

VAR __n = CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy24AnnualScore]))) RETURN IF(__n >= 5, CALCULATE(AVERAGE(PerfEmployee[fy24AnnualScore]), KEEPFILTERS(PerfEmployee[status] = "Active")), BLANK())

Direct dependencies: None

Average Rating (FY25 Annual)

NineBox · Cycle Trend

VAR __n = CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy25AnnualScore]))) RETURN IF(__n >= 5, CALCULATE(AVERAGE(PerfEmployee[fy25AnnualScore]), KEEPFILTERS(PerfEmployee[status] = "Active")), BLANK())

Direct dependencies: None

Average Rating (FY25 Mid-Year)

NineBox · Cycle Trend

VAR __n = CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy25MidScore]))) RETURN IF(__n >= 5, CALCULATE(AVERAGE(PerfEmployee[fy25MidScore]), KEEPFILTERS(PerfEmployee[status] = "Active")), BLANK())

Direct dependencies: None

Average Rating (FY26 Calibrated)

NineBox · Cycle Trend

VAR __n = CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy26CalibratedScore]))) RETURN IF(__n >= 5, CALCULATE(AVERAGE(PerfEmployee[fy26CalibratedScore]), KEEPFILTERS(PerfEmployee[status] = "Active")), BLANK())

Direct dependencies: None

Declined (YoY)

PerfEmployee · Trajectory

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

Direct dependencies: None

Flatlined (YoY)

PerfEmployee · Trajectory

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

Direct dependencies: None

Improved (YoY)

PerfEmployee · Trajectory

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

Direct dependencies: None

Trajectory Eligible

PerfEmployee · Trajectory

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

Direct dependencies: None