Average Midpoint Progression
RangeStructure · Structure Checks
AVERAGE(RangeStructure[midProgressionPct])Direct dependencies: None
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
2 Ranges
DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
Average Range Spread
RangeStructure · Structure Checks
AVERAGE(RangeStructure[spreadPct])Direct dependencies: None
Check: Negative Midpoint Progression
RangeStructure · Structure Checks
COUNTROWS(FILTER(RangeStructure, NOT ISBLANK(RangeStructure[midProgressionPct]) && RangeStructure[midProgressionPct] <= 0)) + 0Direct dependencies: None
Check: Range Order Violations
RangeStructure · Structure Checks
COUNTROWS(FILTER(RangeStructure, NOT (RangeStructure[rangeMin] < RangeStructure[rangeMid] && RangeStructure[rangeMid] < RangeStructure[rangeMax]))) + 0Direct dependencies: None