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)
Differentiation Verdict
PlanBudget · Differentiation
VAR __R = [Differentiation Ratio (High vs Meets)] VAR __Min = CALCULATE(MAX(Parameters[value]), ALL(Parameters), Parameters[name] = "DifferentiationMin") VAR __Strong = CALCULATE(MAX(Parameters[value]), ALL(Parameters), Parameters[name] = "DifferentiationStrong") RETURN IF(ISBLANK(__R), BLANK(), IF(__R < __Min, "Weak", IF(__R < __Strong, "Adequate", "Strong")))
Direct dependencies: Differentiation Ratio (High vs Meets)
Employees (Range Band)
PlanBudget · Report Views
VAR __Lo = SELECTEDVALUE(RangeBand[lo]) VAR __Hi = SELECTEDVALUE(RangeBand[hi]) RETURN IF(ISBLANK(__Lo), BLANK(), CALCULATE([Headcount], KEEPFILTERS(FILTER(CompPlanning, NOT ISBLANK(CompPlanning[preCompaRatio]) && CompPlanning[preCompaRatio] >= __Lo && CompPlanning[preCompaRatio] < __Hi))) + 0)
Direct dependencies: Headcount
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
Heat Cell Color
PlanBudget · Report Views
VAR __N = [Employees (Range Band)] VAR __M = [Merit Avg Increase (Range Band)] RETURN IF(ISBLANK(__N), BLANK(), IF(OR(__N < 5, ISBLANK(__M)), "#F1F3F5", IF(__M >= 0.06, "#9FB4C4", IF(__M >= 0.04, "#C5D3DD", IF(__M >= 0.02, "#E1E8ED", "#F4F6F8")))))
Direct dependencies: Employees (Range Band), Merit Avg Increase (Range Band)
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 Avg Increase (Range Band)
PlanBudget · Report Views
VAR __Lo = SELECTEDVALUE(RangeBand[lo]) VAR __Hi = SELECTEDVALUE(RangeBand[hi]) RETURN IF(ISBLANK(__Lo), BLANK(), CALCULATE([Merit Avg Increase], KEEPFILTERS(FILTER(CompPlanning, NOT ISBLANK(CompPlanning[preCompaRatio]) && CompPlanning[preCompaRatio] >= __Lo && CompPlanning[preCompaRatio] < __Hi))))
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 Grid Cell
PlanBudget · Report Views
VAR __N = [Employees (Range Band)] VAR __M = [Merit Avg Increase (Range Band)] RETURN IF(ISBLANK(__N), BLANK(), IF(__N < 5, "fewer than 5 people", IF(ISBLANK(__M), "no merit increases · " & FORMAT(__N, "#,0") & " people", FORMAT(__M, "0.0%") & " · " & FORMAT(__N, "#,0") & " people")))
Direct dependencies: Employees (Range Band), Merit Avg Increase (Range Band)
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 Spend (All Types)
CompPlanning · Total
[Merit Spend] + [Promo Spend] + [Adj Spend]
Direct dependencies: Merit Spend, Promo Spend, Adj Spend