Adj % of Payroll
CompPlanning · Total
DIVIDE([Adj Spend], [Payroll Base (USD)])Direct dependencies: Adj Spend, Payroll Base (USD)
Choose dashboard — Compensation Cycle
- 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 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.
Selected page
8 Pool and payroll
DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
Adj Avg Increase
CompPlanning · Additional Adjustment
DIVIDE([Adj Spend], [Adj Base])Direct dependencies: Adj Spend, Adj Base
Adj Base
CompPlanning · Additional Adjustment
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN IF(__Adj = "Include", CALCULATE(SUM(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[adjustmentAmountUsd] > 0)), 0)Direct dependencies: None
Adj Spend
CompPlanning · Additional Adjustment
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN IF(__Adj = "Include", CALCULATE(SUM(CompPlanning[adjustmentAmountUsd]), 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"))), 0)Direct dependencies: None
Headcount
CompPlanning · Headcount & Rating
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")))Direct dependencies: None
Increase Base (Any Increase)
CompPlanning · Total
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(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")), FILTER(CompPlanning, CompPlanning[meritAmountUsd] > 0 || CompPlanning[promoAmountUsd] > 0 || (__Adj = "Include" && CompPlanning[adjustmentAmountUsd] > 0)))Direct dependencies: None
Merit % of Payroll
CompPlanning · Total
DIVIDE([Merit Spend], [Payroll Base (USD)])Direct dependencies: Merit Spend, Payroll Base (USD)
Merit Avg Increase
CompPlanning · Merit
DIVIDE([Merit Spend], [Merit Base])Direct dependencies: Merit Spend, Merit Base
Merit Base
CompPlanning · Merit
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(CompPlanning[meritEligibleEarningsUsd]), 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[meritAmountUsd] > 0))Direct dependencies: None
Merit Spend
CompPlanning · Merit
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(CompPlanning[meritAmountUsd]), 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")))Direct dependencies: None
Payroll Base (USD)
CompPlanning · Total
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(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")))Direct dependencies: None
Promo % of Payroll
CompPlanning · Total
DIVIDE([Promo Spend], [Payroll Base (USD)])Direct dependencies: Promo Spend, Payroll Base (USD)
Promo Avg Increase
CompPlanning · Promotion
DIVIDE([Promo Spend], [Promo Base])Direct dependencies: Promo Spend, Promo Base
Promo Base
CompPlanning · Promotion
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(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[promotionFlag] = "Yes"))Direct dependencies: None
Promo Spend
CompPlanning · Promotion
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(CompPlanning[promoAmountUsd]), 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")))Direct dependencies: None
Total % of Payroll
CompPlanning · Total
DIVIDE([Total Spend (All Types)], [Payroll Base (USD)])Direct dependencies: Total Spend (All Types), Payroll Base (USD)
Total Increase Rate (All Types)
CompPlanning · Total
DIVIDE([Total Spend (All Types)], [Increase Base (Any Increase)])Direct dependencies: Total Spend (All Types), Increase Base (Any Increase)
Total Spend (All Types)
CompPlanning · Total
[Merit Spend] + [Promo Spend] + [Adj Spend]Direct dependencies: Merit Spend, Promo Spend, Adj Spend