% of Total Shares Outstanding
StructEmployee · Equity
DIVIDE([Shares Granted], LOOKUPVALUE(Parameters[value], Parameters[name], "TotalSharesOutstanding"))Direct dependencies: Shares Granted
Choose dashboard — Compensation Structure
- 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 Structure
Ranges, market position, pay mix, scenarios, hiring, and within-level equity measures.
11 pages · Power BI
These dashboards use synthetic workforce data. Values illustrate the report design.
Selected page
7 Equity pool
DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
Equity Pool Text
StructEmployee · Report Views
IF([Headcount] = 0, BLANK(), FORMAT([Shares Granted], "#,0") & " shares granted (" & FORMAT([% of Total Shares Outstanding], "0.000%") & " of total shares outstanding), " & FORMAT([Pool Used %], "0.0%") & " of the employee pool; value " & FORMAT([Equity Value (USD)], "$#,##0") & " at the synthetic share price.")Direct dependencies: Headcount, Shares Granted, % of Total Shares Outstanding, Pool Used %, Equity Value (USD)
Equity Value (USD)
StructEmployee · Equity
[Shares Granted] * LOOKUPVALUE(Parameters[value], Parameters[name], "SharePrice")Direct dependencies: Shares Granted
Headcount
StructEmployee · Headcount & Pay
COUNTROWS(StructEmployee)Direct dependencies: None
Pool Used %
StructEmployee · Equity
DIVIDE([Shares Granted], LOOKUPVALUE(Parameters[value], Parameters[name], "PoolSizeShares"))Direct dependencies: Shares Granted
Shares Granted
StructEmployee · Equity
SUM(StructEmployee[equityShares])Direct dependencies: None