Merit % of Payroll (Model 1)
StructEmployee · Merit Scenarios
DIVIDE([Merit Cost (Model 1)], [Payroll Base (USD)])Direct dependencies: Merit Cost (Model 1), Payroll Base (USD)
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
8 Merit scenarios
DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
Merit % of Payroll (Model 2)
StructEmployee · Merit Scenarios
DIVIDE([Merit Cost (Model 2)], [Payroll Base (USD)])Direct dependencies: Merit Cost (Model 2), Payroll Base (USD)
Merit Cost (Model 1)
StructEmployee · Merit Scenarios
SUM(StructEmployee[meritCost1])Direct dependencies: None
Merit Cost (Model 2)
StructEmployee · Merit Scenarios
SUM(StructEmployee[meritCost2])Direct dependencies: None
Model 2 minus Model 1
StructEmployee · Merit Scenarios
[Merit Cost (Model 2)] - [Merit Cost (Model 1)]Direct dependencies: Merit Cost (Model 2), Merit Cost (Model 1)
Payroll Base (USD)
StructEmployee · Headcount & Pay
SUM(StructEmployee[baseUsd])Direct dependencies: None