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 — 6 Representation

Selected page

6 Representation

DAX definitions

Exact source expressions and direct measure dependencies for the selected page.

Active Headcount

RetEmployee · Headcount & Flow

CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"))

Direct dependencies: None

New Hires (12m)

RetEmployee · Headcount & Flow

CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[newHire12m] = "Yes"))

Direct dependencies: None

Non-majority % of Headcount

RetEmployee · Representation

VAR __g = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[ethnicityRollup] = "Non-majority (all other)")) RETURN IF(__g >= 10 && [Active Headcount] >= 10, DIVIDE(__g, [Active Headcount]), BLANK())

Direct dependencies: Active Headcount

Non-majority % of New Hires

RetEmployee · Representation

VAR __g = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[newHire12m] = "Yes"), KEEPFILTERS(RetEmployee[ethnicityRollup] = "Non-majority (all other)")) RETURN IF(__g >= 10 && [New Hires (12m)] >= 10, DIVIDE(__g, [New Hires (12m)]), BLANK())

Direct dependencies: New Hires (12m)

Women % of Headcount

RetEmployee · Representation

VAR __g = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[gender] = "Female")) RETURN IF(__g >= 10 && [Active Headcount] >= 10, DIVIDE(__g, [Active Headcount]), BLANK())

Direct dependencies: Active Headcount

Women % of New Hires

RetEmployee · Representation

VAR __g = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[newHire12m] = "Yes"), KEEPFILTERS(RetEmployee[gender] = "Female")) RETURN IF(__g >= 10 && [New Hires (12m)] >= 10, DIVIDE(__g, [New Hires (12m)]), BLANK())

Direct dependencies: New Hires (12m)