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.

Choose page — 1 Structure summary

Selected page

1 Structure summary

DAX definitions

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

% Above Maximum

StructEmployee · Ranges

DIVIDE([Above Maximum], [Headcount])

Direct dependencies: Above Maximum, Headcount

% Below Minimum

StructEmployee · Ranges

DIVIDE([Below Minimum], [Headcount])

Direct dependencies: Below Minimum, Headcount

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 Market Percentile

StructEmployee · Market

AVERAGE(StructEmployee[marketPercentile])

Direct dependencies: None

Average Target Percentile

StructEmployee · Market

AVERAGE(StructEmployee[targetPercentile])

Direct dependencies: None

Below Minimum

StructEmployee · Ranges

CALCULATE(COUNTROWS(StructEmployee), KEEPFILTERS(StructEmployee[positionBand] = "1 · Below min"))

Direct dependencies: None

Cost to Target

StructEmployee · Market

SUM(StructEmployee[costToTarget])

Direct dependencies: None

Cost to Target % of Payroll

StructEmployee · Market

DIVIDE([Cost to Target], [Payroll Base (USD)])

Direct dependencies: Cost to Target, Payroll Base (USD)

Headcount

StructEmployee · Headcount & Pay

COUNTROWS(StructEmployee)

Direct dependencies: None

Payroll Base (USD)

StructEmployee · Headcount & Pay

SUM(StructEmployee[baseUsd])

Direct dependencies: None

Structure Status Text

StructEmployee · Report Views

IF([Headcount] = 0, BLANK(), FORMAT([Below Minimum] + 0, "#,0") & " of " & FORMAT([Headcount], "#,0") & " employees are paid below their range minimum and " & FORMAT([Above Maximum] + 0, "#,0") & " above the maximum. Average market percentile is " & FORMAT([Average Market Percentile], "0") & " against targets averaging " & FORMAT([Average Target Percentile], "0") & "; moving everyone below their target percentile up to it would cost " & FORMAT([Cost to Target], "$#,##0") & " a year (" & FORMAT([Cost to Target % of Payroll], "0.0%") & " of payroll).")

Direct dependencies: Headcount, Below Minimum, Above Maximum, Average Market Percentile, Average Target Percentile, Cost to Target, Cost to Target % of Payroll