% High Performers
PerfEmployee · Rating
DIVIDE([Count High Performers], [Rated Employees])Direct dependencies: Count High Performers, Rated Employees
people analytics dashboard
Calibration, trajectory, equity screening, talent, readiness, and development views.
19 pages · Power BI
These dashboards use synthetic workforce data. Values illustrate the report design.
Selected page
Exact source expressions and direct measure dependencies for the selected page.
PerfEmployee · Rating
DIVIDE([Count High Performers], [Rated Employees])Direct dependencies: Count High Performers, Rated Employees
PerfEmployee · Rating
DIVIDE([Count Low Performers], [Rated Employees])Direct dependencies: Count Low Performers, Rated Employees
PerfEmployee · Calibration
DIVIDE([Moved Down in Calibration], [Calibrated Employees])Direct dependencies: Moved Down in Calibration, Calibrated Employees
PerfEmployee · Calibration
DIVIDE([Moved Up in Calibration], [Calibrated Employees])Direct dependencies: Moved Up in Calibration, Calibrated Employees
PerfEmployee · Flow & Attrition
([Start Headcount] + [Headcount (As Of)]) / 2Direct dependencies: Start Headcount, Headcount (As Of)
PerfEmployee · Rating
DIVIDE(CALCULATE(SUM(PerfEmployee[mostCurrentScore]), KEEPFILTERS(PerfEmployee[status] = "Active")), [Rated Employees])Direct dependencies: Rated Employees
PerfEmployee · Calibration
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy26ManagerScore]) && NOT ISBLANK(PerfEmployee[fy26CalibratedScore])))Direct dependencies: None
NineBox · Org vs Company
CALCULATE([% Low Performers], REMOVEFILTERS(PerfEmployee))Direct dependencies: % Low Performers
NineBox · Org vs Company
CALCULATE([% High Performers], REMOVEFILTERS(PerfEmployee))Direct dependencies: % High Performers
NineBox · Org vs Company
CALCULATE([Headcount (As Of)], REMOVEFILTERS(PerfEmployee))Direct dependencies: Headcount (As Of)
NineBox · Org vs Company
CALCULATE([Average Rating], REMOVEFILTERS(PerfEmployee))Direct dependencies: Average Rating
NineBox · Org vs Company
CALCULATE([Exit Rate (Window Population)], REMOVEFILTERS(PerfEmployee))Direct dependencies: Exit Rate (Window Population)
NineBox · Org vs Company
CALCULATE([Goal Attainment], REMOVEFILTERS(PerfEmployee))Direct dependencies: Goal Attainment
NineBox · Org vs Company
CALCULATE([Net Calibration Shift], REMOVEFILTERS(PerfEmployee))Direct dependencies: Net Calibration Shift
NineBox · Org vs Company
CALCULATE([Promotion Rate], REMOVEFILTERS(PerfEmployee))Direct dependencies: Promotion Rate
NineBox · Org vs Company
CALCULATE([Rated 4–5 Paid Below 0.90 (% of Rated)], REMOVEFILTERS(PerfEmployee))Direct dependencies: Rated 4–5 Paid Below 0.90 (% of Rated)
NineBox · Org vs Company
CALCULATE([Voluntary Attrition Rate], REMOVEFILTERS(PerfEmployee))Direct dependencies: Voluntary Attrition Rate
PerfEmployee · Rating
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBand] = "High (4-5)"))Direct dependencies: None
PerfEmployee · Rating
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBand] = "Low (1-2)"))Direct dependencies: None
PerfEmployee · Flow & Attrition
DIVIDE([Exits (TTM)], [Population in Window])Direct dependencies: Exits (TTM), 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, NOT ISBLANK(PerfEmployee[terminationDate]) && PerfEmployee[terminationDate] > __Start && PerfEmployee[terminationDate] <= __AsOf))Direct dependencies: None
NineBox · Org vs Company
IF(ISBLANK([Company: % rated 1–2]) || FALSE(), BLANK(), [% Low Performers] + 0 - [Company: % rated 1–2])Direct dependencies: Company: % rated 1–2, % Low Performers
NineBox · Org vs Company
IF(ISBLANK([Company: % rated 4–5]) || FALSE(), BLANK(), [% High Performers] + 0 - [Company: % rated 4–5])Direct dependencies: Company: % rated 4–5, % High Performers
NineBox · Org vs Company
IF(ISBLANK([Company: Average rating]) || ISBLANK([Average Rating]), BLANK(), [Average Rating] - [Company: Average rating])Direct dependencies: Company: Average rating, Average Rating
NineBox · Org vs Company
IF(ISBLANK([Company: Exit rate]) || FALSE(), BLANK(), [Exit Rate (Window Population)] + 0 - [Company: Exit rate])Direct dependencies: Company: Exit rate, Exit Rate (Window Population)
NineBox · Org vs Company
IF(ISBLANK([Company: Goal attainment]) || ISBLANK([Goal Attainment]), BLANK(), [Goal Attainment] - [Company: Goal attainment])Direct dependencies: Company: Goal attainment, Goal Attainment
NineBox · Org vs Company
IF(ISBLANK([Company: Net calibration shift]) || FALSE(), BLANK(), [Net Calibration Shift] + 0 - [Company: Net calibration shift])Direct dependencies: Company: Net calibration shift, Net Calibration Shift
NineBox · Org vs Company
IF(ISBLANK([Company: Promotion rate]) || FALSE(), BLANK(), [Promotion Rate] + 0 - [Company: Promotion rate])Direct dependencies: Company: Promotion rate, Promotion Rate
NineBox · Org vs Company
IF(ISBLANK([Company: Rated 4–5, paid below 0.90 (% of rated)]) || FALSE(), BLANK(), [Rated 4–5 Paid Below 0.90 (% of Rated)] + 0 - [Company: Rated 4–5, paid below 0.90 (% of rated)])Direct dependencies: Company: Rated 4–5, paid below 0.90 (% of rated), Rated 4–5 Paid Below 0.90 (% of Rated)
NineBox · Org vs Company
IF(ISBLANK([Company: Voluntary attrition]) || FALSE(), BLANK(), [Voluntary Attrition Rate] + 0 - [Company: Voluntary attrition])Direct dependencies: Company: Voluntary attrition, Voluntary Attrition Rate
NineBox · Goals
DIVIDE(CALCULATE(SUM(PerfEmployee[goalAttainmentSum]), KEEPFILTERS(PerfEmployee[status] = "Active")), [Goals Set])Direct dependencies: Goals Set
NineBox · Goals
CALCULATE(SUM(PerfEmployee[goalsSet]), KEEPFILTERS(PerfEmployee[status] = "Active"))Direct dependencies: None
PerfEmployee · Flow & Attrition
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"))Direct dependencies: None
PerfEmployee · Calibration
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy26ManagerScore]) && NOT ISBLANK(PerfEmployee[fy26CalibratedScore]) && PerfEmployee[fy26CalibratedScore] < PerfEmployee[fy26ManagerScore]))Direct dependencies: None
PerfEmployee · Calibration
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy26ManagerScore]) && NOT ISBLANK(PerfEmployee[fy26CalibratedScore]) && PerfEmployee[fy26CalibratedScore] > PerfEmployee[fy26ManagerScore]))Direct dependencies: None
PerfEmployee · Calibration
[% Moved Up] - [% Moved Down]Direct dependencies: % Moved Up, % Moved Down
NineBox · Report Views
IF([Headcount (As Of)] = 0, BLANK(), "This selection: " & FORMAT([Headcount (As Of)], "#,0") & " of " & FORMAT([Company: Active headcount], "#,0") & " employees (" & FORMAT([Share of Company Headcount], "0.0%") & "). " & IF([Rated Employees] = 0, "No rated employees", "Average rating " & FORMAT([Average Rating], "0.00") & " vs " & FORMAT([Company: Average rating], "0.00") & " company (" & FORMAT([Gap vs Company: Average rating], "+0.00;-0.00") & ")") & "; exit rate " & FORMAT([Exit Rate (Window Population)] + 0, "0.0%") & " vs " & FORMAT([Company: Exit rate], "0.0%") & " company (" & FORMAT(([Exit Rate (Window Population)] + 0 - [Company: Exit rate]) * 100, "+0.0;-0.0") & " points).")Direct dependencies: Headcount (As Of), Company: Active headcount, Share of Company Headcount, Rated Employees, Average Rating, Company: Average rating, Gap vs Company: Average rating, Exit Rate (Window Population), Company: Exit rate
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
PerfEmployee · Promotion & Pay
DIVIDE([Recent Promotions], [Headcount (As Of)])Direct dependencies: Recent Promotions, Headcount (As Of)
PerfEmployee · Promotion & Pay
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBand] = "High (4-5)"), KEEPFILTERS(PerfEmployee[payBand] = "Low (<0.90)"))Direct dependencies: None
PerfEmployee · Promotion & Pay
DIVIDE([Rated 4–5 Paid Below 0.90], [Rated Employees])Direct dependencies: Rated 4–5 Paid Below 0.90, Rated Employees
PerfEmployee · Rating
CALCULATE(COUNT(PerfEmployee[mostCurrentScore]), KEEPFILTERS(PerfEmployee[status] = "Active"))Direct dependencies: None
PerfEmployee · Promotion & Pay
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[recentPromo] = "Yes"))Direct dependencies: None
NineBox · Org vs Company
DIVIDE([Headcount (As Of)], [Company: Active headcount])Direct dependencies: Headcount (As Of), Company: Active headcount
PerfEmployee · Flow & Attrition
VAR __AsOf = CALCULATE(MAX(AsOf[asOfDate]), ALL(AsOf)) VAR __Start = EDATE(__AsOf, -12) RETURN CALCULATE(COUNTROWS(PerfEmployee), FILTER(PerfEmployee, PerfEmployee[hireDate] <= __Start && (ISBLANK(PerfEmployee[terminationDate]) || PerfEmployee[terminationDate] > __Start)))Direct dependencies: None
PerfEmployee · Flow & Attrition
DIVIDE([Voluntary Exits (TTM)], [Average Headcount])Direct dependencies: Voluntary Exits (TTM), Average Headcount
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