DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
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
Differentiation Ratio (High vs Meets)
PlanBudget · Differentiation
DIVIDE([Merit Avg Increase (High Performers)], [Merit Avg Increase (Meets)])
Direct dependencies: Merit Avg Increase (High Performers), Merit Avg Increase (Meets)
Differentiation Text
PlanBudget · Report Views
IF(ISBLANK([Differentiation Ratio (High vs Meets)]), BLANK(), "Average merit " & FORMAT([Merit Avg Increase (High Performers)], "0.00%") & " for ratings 4–5 vs " & FORMAT([Merit Avg Increase (Meets)], "0.00%") & " for rating 3")
Direct dependencies: Differentiation Ratio (High vs Meets), Merit Avg Increase (High Performers), Merit Avg Increase (Meets)
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 Avg Increase
CompPlanning · Merit
DIVIDE([Merit Spend], [Merit Base])
Direct dependencies: Merit Spend, Merit Base
Merit Avg Increase (High Performers)
PlanBudget · Differentiation
CALCULATE([Merit Avg Increase], KEEPFILTERS(CompPlanning[ratingBand] = "High (4-5)"))
Direct dependencies: Merit Avg Increase
Merit Avg Increase (Meets)
PlanBudget · Differentiation
CALCULATE([Merit Avg Increase], KEEPFILTERS(CompPlanning[ratingBand] = "Meets (3)"))
Direct dependencies: Merit Avg Increase
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
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
Share of All Employees
PlanBudget · Report Views
DIVIDE([Headcount], CALCULATE([Headcount], REMOVEFILTERS(CompPlanning[ratingLabel])))
Direct dependencies: Headcount
Share of All Spend
PlanBudget · Report Views
DIVIDE([Total Spend (All Types)], CALCULATE([Total Spend (All Types)], REMOVEFILTERS(CompPlanning[ratingLabel])))
Direct dependencies: Total Spend (All Types)
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