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 — 2 My org vs company

Selected page

2 My org vs company

DAX definitions

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

% High Performers

PerfEmployee · Rating

DIVIDE([Count High Performers], [Rated Employees])

Direct dependencies: Count High Performers, Rated Employees

% Low Performers

PerfEmployee · Rating

DIVIDE([Count Low Performers], [Rated Employees])

Direct dependencies: Count Low Performers, Rated Employees

% Moved Down

PerfEmployee · Calibration

DIVIDE([Moved Down in Calibration], [Calibrated Employees])

Direct dependencies: Moved Down in Calibration, Calibrated Employees

% Moved Up

PerfEmployee · Calibration

DIVIDE([Moved Up in Calibration], [Calibrated Employees])

Direct dependencies: Moved Up in Calibration, Calibrated Employees

Average Headcount

PerfEmployee · Flow & Attrition

([Start Headcount] + [Headcount (As Of)]) / 2

Direct dependencies: Start Headcount, Headcount (As Of)

Average Rating

PerfEmployee · Rating

DIVIDE(CALCULATE(SUM(PerfEmployee[mostCurrentScore]), KEEPFILTERS(PerfEmployee[status] = "Active")), [Rated Employees])

Direct dependencies: Rated Employees

Calibrated Employees

PerfEmployee · Calibration

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

Direct dependencies: None

Company: % rated 1–2

NineBox · Org vs Company

CALCULATE([% Low Performers], REMOVEFILTERS(PerfEmployee))

Direct dependencies: % Low Performers

Company: % rated 4–5

NineBox · Org vs Company

CALCULATE([% High Performers], REMOVEFILTERS(PerfEmployee))

Direct dependencies: % High Performers

Company: Active headcount

NineBox · Org vs Company

CALCULATE([Headcount (As Of)], REMOVEFILTERS(PerfEmployee))

Direct dependencies: Headcount (As Of)

Company: Average rating

NineBox · Org vs Company

CALCULATE([Average Rating], REMOVEFILTERS(PerfEmployee))

Direct dependencies: Average Rating

Company: Exit rate

NineBox · Org vs Company

CALCULATE([Exit Rate (Window Population)], REMOVEFILTERS(PerfEmployee))

Direct dependencies: Exit Rate (Window Population)

Company: Goal attainment

NineBox · Org vs Company

CALCULATE([Goal Attainment], REMOVEFILTERS(PerfEmployee))

Direct dependencies: Goal Attainment

Company: Net calibration shift

NineBox · Org vs Company

CALCULATE([Net Calibration Shift], REMOVEFILTERS(PerfEmployee))

Direct dependencies: Net Calibration Shift

Company: Promotion rate

NineBox · Org vs Company

CALCULATE([Promotion Rate], REMOVEFILTERS(PerfEmployee))

Direct dependencies: Promotion Rate

Company: Rated 4–5, paid below 0.90 (% of rated)

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)

Company: Voluntary attrition

NineBox · Org vs Company

CALCULATE([Voluntary Attrition Rate], REMOVEFILTERS(PerfEmployee))

Direct dependencies: Voluntary Attrition Rate

Count High Performers

PerfEmployee · Rating

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBand] = "High (4-5)"))

Direct dependencies: None

Count Low Performers

PerfEmployee · Rating

CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[ratingBand] = "Low (1-2)"))

Direct dependencies: None

Exit Rate (Window Population)

PerfEmployee · Flow & Attrition

DIVIDE([Exits (TTM)], [Population in Window])

Direct dependencies: Exits (TTM), Population in Window

Exits (TTM)

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

Gap vs Company: % rated 1–2

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

Gap vs Company: % rated 4–5

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

Gap vs Company: Average rating

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

Gap vs Company: Exit rate

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)

Gap vs Company: Goal attainment

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

Gap vs Company: Net calibration shift

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

Gap vs Company: Promotion rate

NineBox · Org vs Company

IF(ISBLANK([Company: Promotion rate]) || FALSE(), BLANK(), [Promotion Rate] + 0 - [Company: Promotion rate])

Direct dependencies: Company: Promotion rate, Promotion Rate

Gap vs Company: Rated 4–5, paid below 0.90 (% of rated)

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)

Gap vs Company: Voluntary attrition

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

Goal Attainment

NineBox · Goals

DIVIDE(CALCULATE(SUM(PerfEmployee[goalAttainmentSum]), KEEPFILTERS(PerfEmployee[status] = "Active")), [Goals Set])

Direct dependencies: Goals Set

Goals Set

NineBox · Goals

CALCULATE(SUM(PerfEmployee[goalsSet]), KEEPFILTERS(PerfEmployee[status] = "Active"))

Direct dependencies: None

Headcount (As Of)

PerfEmployee · Flow & Attrition

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

Direct dependencies: None

Moved Down in Calibration

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

Moved Up in Calibration

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

Net Calibration Shift

PerfEmployee · Calibration

[% Moved Up] - [% Moved Down]

Direct dependencies: % Moved Up, % Moved Down

Org vs Company Text

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

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, PerfEmployee[hireDate] <= __AsOf && (ISBLANK(PerfEmployee[terminationDate]) || PerfEmployee[terminationDate] > __Start)))

Direct dependencies: None

Promotion Rate

PerfEmployee · Promotion & Pay

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

Direct dependencies: Recent Promotions, Headcount (As Of)

Rated 4–5 Paid Below 0.90

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

Rated 4–5 Paid Below 0.90 (% of Rated)

PerfEmployee · Promotion & Pay

DIVIDE([Rated 4–5 Paid Below 0.90], [Rated Employees])

Direct dependencies: Rated 4–5 Paid Below 0.90, Rated Employees

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

Share of Company Headcount

NineBox · Org vs Company

DIVIDE([Headcount (As Of)], [Company: Active headcount])

Direct dependencies: Headcount (As Of), Company: Active headcount

Start 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

Voluntary Attrition Rate

PerfEmployee · Flow & Attrition

DIVIDE([Voluntary Exits (TTM)], [Average Headcount])

Direct dependencies: Voluntary Exits (TTM), Average Headcount

Voluntary Exits (TTM)

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