Base Share of OTE
StructEmployee · Pay Mix
DIVIDE(CALCULATE(SUM(StructEmployee[baseUsd]), FILTER(StructEmployee, StructEmployee[commissionTargetUsd] > 0)), [OTE (Commission Eligible)])Direct dependencies: OTE (Commission Eligible)
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
6 Pay mix and OTE
DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
Bonus % of Base
StructEmployee · Pay Mix
DIVIDE(SUM(StructEmployee[bonusUsd]), CALCULATE(SUM(StructEmployee[baseUsd]), FILTER(StructEmployee, StructEmployee[bonusUsd] > 0)))Direct dependencies: None
Commission Eligible
StructEmployee · Pay Mix
CALCULATE(COUNTROWS(StructEmployee), FILTER(StructEmployee, StructEmployee[commissionTargetUsd] > 0))Direct dependencies: None
OTE (Commission Eligible)
StructEmployee · Pay Mix
CALCULATE(SUM(StructEmployee[oteUsd]), FILTER(StructEmployee, StructEmployee[commissionTargetUsd] > 0))Direct dependencies: None
Total Cash (USD)
StructEmployee · Pay Mix
SUM(StructEmployee[totalCashUsd])Direct dependencies: None