% Goals Aligned
NineBox · Goals
DIVIDE(CALCULATE(SUM(PerfEmployee[goalsAligned]), KEEPFILTERS(PerfEmployee[status] = "Active")), [Goals Set])Direct dependencies: Goals Set
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.
NineBox · Goals
DIVIDE(CALCULATE(SUM(PerfEmployee[goalsAligned]), KEEPFILTERS(PerfEmployee[status] = "Active")), [Goals Set])Direct dependencies: Goals Set
NineBox · Goals
DIVIDE(CALCULATE(SUM(PerfEmployee[goalsAttainedFull]), KEEPFILTERS(PerfEmployee[status] = "Active")), [Goals Set])Direct dependencies: Goals Set
NineBox · Review Process
DIVIDE([Manager Reviews Late], [Manager Ratings Entered])Direct dependencies: Manager Reviews Late, Manager Ratings Entered
NineBox · Review Process
DIVIDE(CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[calibrationCovered] = "Yes")), [Manager Ratings Entered])Direct dependencies: Manager Ratings Entered
NineBox · Goals
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[goalsSet] > 0))Direct dependencies: None
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
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
PerfEmployee · Flow & Attrition
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"))Direct dependencies: None
NineBox · Review Process
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), FILTER(PerfEmployee, NOT ISBLANK(PerfEmployee[fy26ManagerScore])))Direct dependencies: None
NineBox · Review Process
CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[managerReviewStatus] = "Late"))Direct dependencies: None
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
NineBox · Review Process
DIVIDE(CALCULATE(COUNTROWS(PerfEmployee), KEEPFILTERS(PerfEmployee[status] = "Active"), KEEPFILTERS(PerfEmployee[selfReviewStatus] = "Submitted")), [Headcount (As Of)])Direct dependencies: Headcount (As Of)
NineBox · Review Process
AVERAGEX(FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[selfScore]) && NOT ISBLANK(PerfEmployee[fy26ManagerScore])), PerfEmployee[selfScore] - PerfEmployee[fy26ManagerScore])Direct dependencies: None