Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Compensation Cycle

people analytics dashboard

Compensation Cycle

Review-cycle planning, market position, distribution, spend, and equity measures.

10 pages · Power BI

These dashboards use synthetic workforce data. Values illustrate the report design.

Choose page — 9 Pay equity

Selected page

9 Pay equity

DAX definitions

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

Ethnicity Pay Ratio (Non-majority ÷ Majority)

PlanBudget · Pay Equity

IF(MIN([Headcount (Non-majority)] + 0, [Headcount (Majority)] + 0) < 5, BLANK(), DIVIDE(VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(AVERAGE(CompPlanning[currentBaseUsd]), FILTER(CompPlanning, (__Geo = "World" || (__Geo = "US Only" && CompPlanning[country] = "United States") || (__Geo = "Rest of World" && CompPlanning[country] <> "United States")) && (__Ind = "Include India" || CompPlanning[country] <> "India")), KEEPFILTERS(CompPlanning[ethnicityRollup] = "Non-majority (all other)")), VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(AVERAGE(CompPlanning[currentBaseUsd]), FILTER(CompPlanning, (__Geo = "World" || (__Geo = "US Only" && CompPlanning[country] = "United States") || (__Geo = "Rest of World" && CompPlanning[country] <> "United States")) && (__Ind = "Include India" || CompPlanning[country] <> "India")), KEEPFILTERS(CompPlanning[ethnicityRollup] = "Majority (White)"))))

Direct dependencies: Headcount (Non-majority), Headcount (Majority)

Gender Pay Ratio (Women ÷ Men)

PlanBudget · Pay Equity

IF(MIN([Headcount (Women)] + 0, [Headcount (Men)] + 0) < 5, BLANK(), DIVIDE(VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(AVERAGE(CompPlanning[currentBaseUsd]), FILTER(CompPlanning, (__Geo = "World" || (__Geo = "US Only" && CompPlanning[country] = "United States") || (__Geo = "Rest of World" && CompPlanning[country] <> "United States")) && (__Ind = "Include India" || CompPlanning[country] <> "India")), KEEPFILTERS(CompPlanning[gender] = "Female")), VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(AVERAGE(CompPlanning[currentBaseUsd]), FILTER(CompPlanning, (__Geo = "World" || (__Geo = "US Only" && CompPlanning[country] = "United States") || (__Geo = "Rest of World" && CompPlanning[country] <> "United States")) && (__Ind = "Include India" || CompPlanning[country] <> "India")), KEEPFILTERS(CompPlanning[gender] = "Male"))))

Direct dependencies: Headcount (Women), Headcount (Men)

Headcount (Majority)

PlanBudget · Pay Equity

VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(COUNTROWS(CompPlanning), FILTER(CompPlanning, (__Geo = "World" || (__Geo = "US Only" && CompPlanning[country] = "United States") || (__Geo = "Rest of World" && CompPlanning[country] <> "United States")) && (__Ind = "Include India" || CompPlanning[country] <> "India")), KEEPFILTERS(CompPlanning[ethnicityRollup] = "Majority (White)"))

Direct dependencies: None

Headcount (Men)

PlanBudget · Pay Equity

VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(COUNTROWS(CompPlanning), FILTER(CompPlanning, (__Geo = "World" || (__Geo = "US Only" && CompPlanning[country] = "United States") || (__Geo = "Rest of World" && CompPlanning[country] <> "United States")) && (__Ind = "Include India" || CompPlanning[country] <> "India")), KEEPFILTERS(CompPlanning[gender] = "Male"))

Direct dependencies: None

Headcount (Non-majority)

PlanBudget · Pay Equity

VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(COUNTROWS(CompPlanning), FILTER(CompPlanning, (__Geo = "World" || (__Geo = "US Only" && CompPlanning[country] = "United States") || (__Geo = "Rest of World" && CompPlanning[country] <> "United States")) && (__Ind = "Include India" || CompPlanning[country] <> "India")), KEEPFILTERS(CompPlanning[ethnicityRollup] = "Non-majority (all other)"))

Direct dependencies: None

Headcount (Women)

PlanBudget · Pay Equity

VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(COUNTROWS(CompPlanning), FILTER(CompPlanning, (__Geo = "World" || (__Geo = "US Only" && CompPlanning[country] = "United States") || (__Geo = "Rest of World" && CompPlanning[country] <> "United States")) && (__Ind = "Include India" || CompPlanning[country] <> "India")), KEEPFILTERS(CompPlanning[gender] = "Female"))

Direct dependencies: None