Bicycle.LLCSchedule a call

← Dashboard collection

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 — 18 Readiness and succession

Selected page

18 Readiness and succession

DAX definitions

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

High Performer Not High Potential Count

NineBox · Talent Grid & Potential

VAR __base = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating]) && NOT ISBLANK(PerfEmployee[mostCurrentScore]) && PerfEmployee[mostCurrentScore] >= 4) VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, NOT (PerfEmployee[potentialRating] = "3 · High"))) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10), BLANK(), __g)

Direct dependencies: None

High Potential Exit Rate

NineBox · Talent Grid & Potential

VAR __AsOf = CALCULATE(MAX(AsOf[asOfDate]), ALL(AsOf)) VAR __Start = EDATE(__AsOf, -12) VAR __base = FILTER(PerfEmployee, PerfEmployee[hireDate] <= __AsOf && (ISBLANK(PerfEmployee[terminationDate]) || PerfEmployee[terminationDate] > __Start) && PerfEmployee[potentialRating] = "3 · High") VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, NOT ISBLANK(PerfEmployee[terminationDate]) && PerfEmployee[terminationDate] > __Start && PerfEmployee[terminationDate] <= __AsOf)) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10) || (__n - __g > 0 && __n - __g < 10), BLANK(), DIVIDE(__g, __n))

Direct dependencies: None

High Potential Exits

NineBox · Talent Grid & Potential

VAR __AsOf = CALCULATE(MAX(AsOf[asOfDate]), ALL(AsOf)) VAR __Start = EDATE(__AsOf, -12) VAR __base = FILTER(PerfEmployee, PerfEmployee[hireDate] <= __AsOf && (ISBLANK(PerfEmployee[terminationDate]) || PerfEmployee[terminationDate] > __Start) && PerfEmployee[potentialRating] = "3 · High") VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, NOT ISBLANK(PerfEmployee[terminationDate]) && PerfEmployee[terminationDate] > __Start && PerfEmployee[terminationDate] <= __AsOf)) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10), BLANK(), __g)

Direct dependencies: None

Ready-Now Share

NineBox · Talent Grid & Potential

VAR __base = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating]) && NOT ISBLANK(PerfEmployee[promotionReadiness])) VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, PerfEmployee[promotionReadiness] = "1 · Ready now")) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10) || (__n - __g > 0 && __n - __g < 10), BLANK(), DIVIDE(__g, __n))

Direct dependencies: None

Ready-Now Share among rated 4-5

NineBox · Talent Grid & Potential

VAR __base = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating]) && NOT ISBLANK(PerfEmployee[mostCurrentScore]) && PerfEmployee[mostCurrentScore] >= 4 && NOT ISBLANK(PerfEmployee[promotionReadiness])) VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, PerfEmployee[promotionReadiness] = "1 · Ready now")) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10) || (__n - __g > 0 && __n - __g < 10), BLANK(), DIVIDE(__g, __n))

Direct dependencies: None

Succession Readiness Text

NineBox · Talent Grid & Potential

IF(ISBLANK([Ready-Now Share among rated 4-5]), BLANK(), "ILLUSTRATIVE: ready now among rated 4-5 " & FORMAT([Ready-Now Share among rated 4-5], "0.0%", "en-US") & ". Employee readiness, not role coverage. Screening, not a verdict.")

Direct dependencies: Ready-Now Share among rated 4-5