% Above Maximum
StructEmployee · Ranges
DIVIDE([Above Maximum], [Headcount])Direct dependencies: Above Maximum, Headcount
Choose dashboard — Compensation Structure
- Executive
- Headcount Plan
- Retention and Composition
- Engagement and Exit
- Talent Acquisition Funnel
- Performance Calibration
- Compensation Cycle
- Compensation Structure
- Succession and Talent Ops
- Workforce Economics
- Wellbeing & retention outcomes
- Performance outcomes
- Engineering delivery outcomes
- Safety & quality outcomes
- Sales outcomes
- Service & customer experience outcomes
people analytics dashboard
Compensation Structure
Ranges, market position, pay mix, scenarios, hiring, and within-level equity measures.
11 pages · Power BI
These dashboards use synthetic workforce data. Values illustrate the report design.
Selected page
3 Range penetration
DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
% Below Minimum
StructEmployee · Ranges
DIVIDE([Below Minimum], [Headcount])Direct dependencies: Below Minimum, Headcount
% In Range
StructEmployee · Ranges
DIVIDE([Headcount] - [Below Minimum] - [Above Maximum], [Headcount])Direct dependencies: Headcount, Below Minimum, Above Maximum
Above Maximum
StructEmployee · Ranges
CALCULATE(COUNTROWS(StructEmployee), KEEPFILTERS(StructEmployee[positionBand] = "5 · Above max"))Direct dependencies: None
Average Compa-Ratio
StructEmployee · Ranges
AVERAGE(StructEmployee[compaRatio])Direct dependencies: None
Average Range Penetration
StructEmployee · Ranges
AVERAGE(StructEmployee[rangePenetration])Direct dependencies: None
Below Minimum
StructEmployee · Ranges
CALCULATE(COUNTROWS(StructEmployee), KEEPFILTERS(StructEmployee[positionBand] = "1 · Below min"))Direct dependencies: None
Headcount
StructEmployee · Headcount & Pay
COUNTROWS(StructEmployee)Direct dependencies: None