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
Change vs Prior Year
PlanBudget · Plan
[Total Spend (All Types)] - [Prior Year Spend (Total)]
Direct dependencies: Total Spend (All Types), Prior Year Spend (Total)
Change vs Prior Year %
PlanBudget · Plan
DIVIDE([Change vs Prior Year], [Prior Year Spend (Total)])
Direct dependencies: Change vs Prior Year, Prior Year Spend (Total)
Gross Over Plan
PlanBudget · Review Gate
SUMX(VALUES(CompPlanning[department]), MAX([Plan Variance (Total)], 0))
Direct dependencies: Plan Variance (Total)
Gross Text
PlanBudget · Report Views
"The small net difference hides offsetting departments: " & FORMAT([Gross Over Plan], "$#,0") & " over plan and " & FORMAT(-[Gross Under Plan], "$#,0") & " under. Review threshold ±" & FORMAT([Variance Tolerance], "0%") & " (assumed, policy unconfirmed)."
Direct dependencies: Gross Over Plan, Gross Under Plan, Variance Tolerance
Gross Under Plan
PlanBudget · Review Gate
SUMX(VALUES(CompPlanning[department]), MIN([Plan Variance (Total)], 0))
Direct dependencies: Plan Variance (Total)
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
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
Plan Budget (Merit)
PlanBudget · Plan
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(PlanBudget[meritBudgetUsd]), TREATAS(SUMMARIZE(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")), CompPlanning[department], CompPlanning[population]), PlanBudget[department], PlanBudget[population]))
Direct dependencies: None
Plan Budget (Other)
PlanBudget · Plan
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(PlanBudget[otherBudgetUsd]), TREATAS(SUMMARIZE(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")), CompPlanning[department], CompPlanning[population]), PlanBudget[department], PlanBudget[population])), 0)
Direct dependencies: None
Plan Budget (Promo)
PlanBudget · Plan
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(PlanBudget[promoBudgetUsd]), TREATAS(SUMMARIZE(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")), CompPlanning[department], CompPlanning[population]), PlanBudget[department], PlanBudget[population]))
Direct dependencies: None
Plan Budget (Total)
PlanBudget · Plan
[Plan Budget (Merit)] + [Plan Budget (Promo)] + [Plan Budget (Other)]
Direct dependencies: Plan Budget (Merit), Plan Budget (Promo), Plan Budget (Other)
Plan Variance %
PlanBudget · Plan
DIVIDE([Plan Variance (Total)], [Plan Budget (Total)])
Direct dependencies: Plan Variance (Total), Plan Budget (Total)
Plan Variance (Total)
PlanBudget · Plan
[Total Spend (All Types)] - [Plan Budget (Total)]
Direct dependencies: Total Spend (All Types), Plan Budget (Total)
Prior Year Spend (Total)
PlanBudget · Plan
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(PlanBudget[priorMeritUsd]) + SUM(PlanBudget[priorPromoUsd]) + IF(__Adj = "Include", SUM(PlanBudget[priorOtherUsd]), 0), TREATAS(SUMMARIZE(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")), CompPlanning[department], CompPlanning[population]), PlanBudget[department], PlanBudget[population]))
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 Spend (All Types)
CompPlanning · Total
[Merit Spend] + [Promo Spend] + [Adj Spend]
Direct dependencies: Merit Spend, Promo Spend, Adj Spend
Variance Flag Color
PlanBudget · Report Views
IF(ISBLANK([Plan Variance %]), BLANK(), IF(ABS([Plan Variance %]) > [Variance Tolerance], "#B7791F", "#4A6070"))
Direct dependencies: Plan Variance %, Variance Tolerance
Variance Tolerance
PlanBudget · Review Gate
CALCULATE(MAX(Parameters[value]), ALL(Parameters), Parameters[name] = "VarianceTolerance")
Direct dependencies: None