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 — 13 Goals and reviews

Selected page

13 Goals and reviews

DAX definitions

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

% Goals Aligned

NineBox · Goals

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

Direct dependencies: Goals Set

% Goals Fully Attained

NineBox · Goals

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

Direct dependencies: Goals Set

% Manager Reviews Late

NineBox · Review Process

DIVIDE([Manager Reviews Late], [Manager Ratings Entered])

Direct dependencies: Manager Reviews Late, Manager Ratings Entered

Calibration Coverage

NineBox · Review Process

DIVIDE(CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[calibrationCovered] = "Yes")), [Manager Ratings Entered])

Direct dependencies: Manager Ratings Entered

Employees With Goals

NineBox · Goals

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

Direct dependencies: None

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

Goals Text

NineBox · Report Views

IF(ISBLANK([Goals Set]), BLANK(), "Average goal attainment " & FORMAT([Goal Attainment], "0.0%") & " across " & FORMAT([Goals Set], "#,0") & " goals: " & FORMAT([% Goals Fully Attained], "0.0%") & " fully attained, " & FORMAT([% Goals Aligned], "0.0%") & " aligned to company goals.")

Direct dependencies: Goals Set, Goal Attainment, % Goals Fully Attained, % Goals Aligned

Headcount (As Of)

PerfEmployee · Flow & Attrition

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

Direct dependencies: None

Manager Ratings Entered

NineBox · Review Process

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

Direct dependencies: None

Manager Reviews Late

NineBox · Review Process

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

Direct dependencies: None

Review Process Text

NineBox · Report Views

IF([Manager Ratings Entered] = 0, BLANK(), FORMAT([Self Review Completion], "0.0%") & " of employees submitted a self review; " & FORMAT([% Manager Reviews Late] + 0, "0.0%") & " of manager reviews were late; " & FORMAT([Calibration Coverage] + 0, "0.0%") & " of manager ratings were covered in calibration.")

Direct dependencies: Manager Ratings Entered, Self Review Completion, % Manager Reviews Late, Calibration Coverage

Self Review Completion

NineBox · Review Process

DIVIDE(CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[selfReviewStatus] = "Submitted")), [Headcount (As Of)])

Direct dependencies: Headcount (As Of)

Self-Manager Gap

NineBox · Review Process

AVERAGEX(FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[selfScore]) && NOT ISBLANK(PerfEmployee[fy26ManagerScore])), PerfEmployee[selfScore] - PerfEmployee[fy26ManagerScore])

Direct dependencies: None