% High Perf
CompPlanning · Headcount & Rating
DIVIDE([Count High Perf], [Count Rated])Direct dependencies: Count High Perf, Count Rated
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.
Choose page — 5 Summary: department and rating
Selected page
5 Summary: department and rating
DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
% Low Perf
CompPlanning · Headcount & Rating
DIVIDE([Count Low Perf], [Count Rated])Direct dependencies: Count Low Perf, Count Rated
% Promoted
CompPlanning · Promotion
DIVIDE([Count Promoted], [Headcount])Direct dependencies: Count Promoted, Headcount
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
Average Perf Rating
CompPlanning · Headcount & Rating
DIVIDE([Sum Rating Score], [Count Rated])Direct dependencies: Sum Rating Score, Count Rated
Avg Refresh Grant Value ($)
CompPlanning · Equity
DIVIDE([Sum Refresh RSUs] * [Stock Price], [Count Received Refresh RSU])Direct dependencies: Sum Refresh RSUs, Stock Price, Count Received Refresh RSU
Count High Perf
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")), KEEPFILTERS(CompPlanning[ratingBand] = "High (4-5)"))Direct dependencies: None
Count Low Perf
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")), KEEPFILTERS(CompPlanning[ratingBand] = "Low (1-2)"))Direct dependencies: None
Count Promoted
CompPlanning · Promotion
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")), KEEPFILTERS(CompPlanning[promotionFlag] = "Yes"))Direct dependencies: None
Count Rated
CompPlanning · Headcount & Rating
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(COUNT(CompPlanning[ratingScore]), 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
Count Received Refresh RSU
CompPlanning · Equity
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")), KEEPFILTERS(CompPlanning[refreshRsu] > 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 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
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
Refresh Participation Rate
CompPlanning · Equity
DIVIDE([Count Received Refresh RSU], [Headcount])Direct dependencies: Count Received Refresh RSU, Headcount
Stock Price
CompPlanning · Equity
CALCULATE(MAX(Parameters[value]), ALL(Parameters), Parameters[name] = "StockPrice")Direct dependencies: None
Sum Rating Score
CompPlanning · Headcount & Rating
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(CompPlanning[ratingScore]), 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
Sum Refresh RSUs
CompPlanning · Equity
VAR __Geo = SELECTEDVALUE(GeoScope[scope], "World") VAR __Ind = SELECTEDVALUE(IndiaScope[scope], "Include India") VAR __Adj = SELECTEDVALUE(AdjToggle[scope], "Include") RETURN CALCULATE(SUM(CompPlanning[refreshRsu]), 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 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