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 — 14 Output and rating

Selected page

14 Output and rating

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

% Rating 1

PerfEmployee · Rating

DIVIDE([Count Rating 1], [Rated Employees])

Direct dependencies: Count Rating 1, Rated Employees

% Rating 2

PerfEmployee · Rating

DIVIDE([Count Rating 2], [Rated Employees])

Direct dependencies: Count Rating 2, Rated Employees

% Rating 3

PerfEmployee · Rating

DIVIDE([Count Rating 3], [Rated Employees])

Direct dependencies: Count Rating 3, Rated Employees

% Rating 4

PerfEmployee · Rating

DIVIDE([Count Rating 4], [Rated Employees])

Direct dependencies: Count Rating 4, Rated Employees

% Rating 5

PerfEmployee · Rating

DIVIDE([Count Rating 5], [Rated Employees])

Direct dependencies: Count Rating 5, Rated Employees

Average Rating

PerfEmployee · Rating

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

Direct dependencies: Rated Employees

Count High Performers

PerfEmployee · Rating

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

Direct dependencies: None

Count Rating 1

PerfEmployee · Rating

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

Direct dependencies: None

Count Rating 2

PerfEmployee · Rating

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

Direct dependencies: None

Count Rating 3

PerfEmployee · Rating

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

Direct dependencies: None

Count Rating 4

PerfEmployee · Rating

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

Direct dependencies: None

Count Rating 5

PerfEmployee · Rating

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

Direct dependencies: None

Rated Employees

PerfEmployee · Rating

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

Direct dependencies: None