DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
At or Above 1.10 (Post-Cycle)
PlanBudget · Review Gate
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN IF(__Adj = "Include", 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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[postCompaRatioWithAdj]) && CompPlanning[postCompaRatioWithAdj] >= 1.1)), 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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[postCompaRatioNoAdj]) && CompPlanning[postCompaRatioNoAdj] >= 1.1)))
Direct dependencies: None
At or Above 1.10 (Pre-Cycle)
PlanBudget · Review Gate
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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[preCompaRatio]) && CompPlanning[preCompaRatio] >= 1.1))
Direct dependencies: None
Below 0.90 (Post-Cycle)
PlanBudget · Review Gate
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN IF(__Adj = "Include", 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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[postCompaRatioWithAdj]) && CompPlanning[postCompaRatioWithAdj] < 0.9)), 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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[postCompaRatioNoAdj]) && CompPlanning[postCompaRatioNoAdj] < 0.9)))
Direct dependencies: None
Below 0.90 (Pre-Cycle)
PlanBudget · Review Gate
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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[preCompaRatio]) && CompPlanning[preCompaRatio] < 0.9))
Direct dependencies: None
Employees in Band (Period)
PlanBudget · Report Views
VAR __P = SELECTEDVALUE(Period[sortOrder]) VAR __Lo = SELECTEDVALUE(RangeBand[lo]) VAR __Hi = SELECTEDVALUE(RangeBand[hi]) VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN IF(OR(ISBLANK(__P), ISBLANK(__Lo)), BLANK(), IF(__P = 1, 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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[preCompaRatio]) && CompPlanning[preCompaRatio] >= __Lo && CompPlanning[preCompaRatio] < __Hi)), IF(__Adj = "Include", 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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[postCompaRatioWithAdj]) && CompPlanning[postCompaRatioWithAdj] >= __Lo && CompPlanning[postCompaRatioWithAdj] < __Hi)), 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")), FILTER(CompPlanning, NOT ISBLANK(CompPlanning[postCompaRatioNoAdj]) && CompPlanning[postCompaRatioNoAdj] >= __Lo && CompPlanning[postCompaRatioNoAdj] < __Hi)))) + 0)
Direct dependencies: None
Employees in Bucket (Post-Cycle)
CompPlanning · Compa-Ratio
VAR __B = SELECTEDVALUE(CompaBands[bucket]) VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN IF(ISBLANK(__B), BLANK(), IF(__Adj = "Include", 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")), FILTER(CompPlanning, ROUND(CompPlanning[postCompaBucketWithAdj], 2) = ROUND(__B, 2))), 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")), FILTER(CompPlanning, ROUND(CompPlanning[postCompaBucketNoAdj], 2) = ROUND(__B, 2)))) + 0)
Direct dependencies: None
Employees in Bucket (Pre-Cycle)
CompPlanning · Compa-Ratio
VAR __B = SELECTEDVALUE(CompaBands[bucket]) VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN IF(ISBLANK(__B), BLANK(), 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")), FILTER(CompPlanning, ROUND(CompPlanning[preCompaBucket], 2) = ROUND(__B, 2))) + 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
Market Text
PlanBudget · Report Views
IF(ISBLANK([Headcount]), BLANK(), "Below 0.90: " & FORMAT([Below 0.90 (Pre-Cycle)] + 0, "#,0") & " before, " & FORMAT([Below 0.90 (Post-Cycle)] + 0, "#,0") & " after. At or above 1.10: " & FORMAT([At or Above 1.10 (Pre-Cycle)] + 0, "#,0") & " before, " & FORMAT([At or Above 1.10 (Post-Cycle)] + 0, "#,0") & " after.")
Direct dependencies: Headcount, Below 0.90 (Pre-Cycle), Below 0.90 (Post-Cycle), At or Above 1.10 (Pre-Cycle), At or Above 1.10 (Post-Cycle)