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 — 19 Development and pay for potential

Selected page

19 Development and pay for potential

DAX definitions

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

High Potential Promotion Rate Ratio

NineBox · Talent Grid & Potential

IF(ISBLANK([Promotion Rate of High Potentials]) || ISBLANK([Promotion Rate of Others]), BLANK(), DIVIDE([Promotion Rate of High Potentials], [Promotion Rate of Others]))

Direct dependencies: Promotion Rate of High Potentials, Promotion Rate of Others

Pay Position of High Potentials

NineBox · Talent Grid & Potential

VAR __rows = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating]) && PerfEmployee[potentialRating] = "3 · High" && NOT ISBLANK(PerfEmployee[ttcCompaRatioPost])) RETURN IF(COUNTROWS(__rows) < 10, BLANK(), AVERAGEX(__rows, PerfEmployee[ttcCompaRatioPost]))

Direct dependencies: None

Promotion Rate of High Potentials

NineBox · Talent Grid & Potential

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

Direct dependencies: None

Promotion Rate of Others

NineBox · Talent Grid & Potential

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

Direct dependencies: None

Training Hours per Employee

NineBox · Talent Grid & Potential

VAR __rows = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[trainingHours])) RETURN IF(COUNTROWS(__rows) < 10, BLANK(), AVERAGEX(__rows, PerfEmployee[trainingHours]))

Direct dependencies: None