Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Compensation Structure

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.

Choose page — 10 Equity within level

Selected page

10 Equity within level

DAX definitions

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

Compa-Ratio (Majority)

StructEmployee · Equity Within Level

VAR __n = CALCULATE(COUNTROWS(StructEmployee), KEEPFILTERS(StructEmployee[ethnicityRollup] = "Majority (White)")) RETURN IF(__n >= 5, CALCULATE(AVERAGE(StructEmployee[compaRatio]), KEEPFILTERS(StructEmployee[ethnicityRollup] = "Majority (White)")), BLANK())

Direct dependencies: None

Compa-Ratio (Men)

StructEmployee · Equity Within Level

VAR __n = CALCULATE(COUNTROWS(StructEmployee), KEEPFILTERS(StructEmployee[gender] = "Male")) RETURN IF(__n >= 5, CALCULATE(AVERAGE(StructEmployee[compaRatio]), KEEPFILTERS(StructEmployee[gender] = "Male")), BLANK())

Direct dependencies: None

Compa-Ratio (Non-majority)

StructEmployee · Equity Within Level

VAR __n = CALCULATE(COUNTROWS(StructEmployee), KEEPFILTERS(StructEmployee[ethnicityRollup] = "Non-majority (all other)")) RETURN IF(__n >= 5, CALCULATE(AVERAGE(StructEmployee[compaRatio]), KEEPFILTERS(StructEmployee[ethnicityRollup] = "Non-majority (all other)")), BLANK())

Direct dependencies: None

Compa-Ratio (Women)

StructEmployee · Equity Within Level

VAR __n = CALCULATE(COUNTROWS(StructEmployee), KEEPFILTERS(StructEmployee[gender] = "Female")) RETURN IF(__n >= 5, CALCULATE(AVERAGE(StructEmployee[compaRatio]), KEEPFILTERS(StructEmployee[gender] = "Female")), BLANK())

Direct dependencies: None

Compa-Ratio Gap (Non-majority − Majority)

StructEmployee · Equity Within Level

IF(ISBLANK([Compa-Ratio (Non-majority)]) || ISBLANK([Compa-Ratio (Majority)]), BLANK(), [Compa-Ratio (Non-majority)] - [Compa-Ratio (Majority)])

Direct dependencies: Compa-Ratio (Non-majority), Compa-Ratio (Majority)

Compa-Ratio Gap (Women − Men)

StructEmployee · Equity Within Level

IF(ISBLANK([Compa-Ratio (Women)]) || ISBLANK([Compa-Ratio (Men)]), BLANK(), [Compa-Ratio (Women)] - [Compa-Ratio (Men)])

Direct dependencies: Compa-Ratio (Women), Compa-Ratio (Men)

Headcount

StructEmployee · Headcount & Pay

COUNTROWS(StructEmployee)

Direct dependencies: None