Active Headcount
RetEmployee · Headcount & Flow
CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"))Direct dependencies: None
Choose dashboard — Retention and Composition
- 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
Retention and Composition
Retention, tenure, turnover cost, representation, and screening views.
8 pages · Power BI
These dashboards use synthetic workforce data. Values illustrate the report design.
Choose page — 3 Tenure and early attrition
Selected page
3 Tenure and early attrition
DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
Average Tenure (Active, Years)
RetEmployee · Tenure & Early Attrition
CALCULATE(AVERAGE(RetEmployee[tenureYears]), KEEPFILTERS(RetEmployee[status] = "Active"))Direct dependencies: None
Exit Rate (Window Population)
RetEmployee · Headcount & Flow
DIVIDE([Exits (TTM)], [People in Window])Direct dependencies: Exits (TTM), People in Window
Exits (TTM)
RetEmployee · Headcount & Flow
CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Terminated"))Direct dependencies: None
New Hires (12m)
RetEmployee · Headcount & Flow
CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[newHire12m] = "Yes"))Direct dependencies: None
New-Hire Exit Rate
RetEmployee · Tenure & Early Attrition
DIVIDE([New-Hire Exits], [New Hires (12m)])Direct dependencies: New-Hire Exits, New Hires (12m)
New-Hire Exits
RetEmployee · Tenure & Early Attrition
CALCULATE(COUNTROWS(RetEmployee), FILTER(RetEmployee, RetEmployee[newHire12m] = "Yes" && RetEmployee[status] = "Terminated"))Direct dependencies: None
People in Window
RetEmployee · Headcount & Flow
COUNTROWS(RetEmployee)Direct dependencies: None
Retention of Start Cohort
RetEmployee · Tenure & Early Attrition
IF(ISBLANK([Start Headcount]) || [Start Headcount] = 0, BLANK(), 1 - DIVIDE([Start-Cohort Exits] + 0, [Start Headcount]))Direct dependencies: Start Headcount, Start-Cohort Exits
Start Headcount
RetEmployee · Headcount & Flow
CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[startCohort] = "Yes"))Direct dependencies: None
Start-Cohort Exits
RetEmployee · Tenure & Early Attrition
CALCULATE(COUNTROWS(RetEmployee), FILTER(RetEmployee, RetEmployee[startCohort] = "Yes" && RetEmployee[status] = "Terminated"))Direct dependencies: None