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 — 5 Retention risk and impact

Selected page

5 Retention risk and impact

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

Expected Loss (USD)

RetEmployee · Retention Risk

SUM(RetEmployee[expectedLossUsd])

Direct dependencies: None

High-Risk Employees

RetEmployee · Retention Risk

CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[riskBand] = "High"))

Direct dependencies: None

High-Risk Share (Majority)

RetEmployee · Representation

VAR __a = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[ethnicityRollup] = "Majority (White)")) RETURN IF(__a >= 10, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[riskBand] = "High"), KEEPFILTERS(RetEmployee[ethnicityRollup] = "Majority (White)")), __a), BLANK())

Direct dependencies: None

High-Risk Share (Men)

RetEmployee · Representation

VAR __a = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[gender] = "Male")) RETURN IF(__a >= 10, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[riskBand] = "High"), KEEPFILTERS(RetEmployee[gender] = "Male")), __a), BLANK())

Direct dependencies: None

High-Risk Share (Non-majority)

RetEmployee · Representation

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

Direct dependencies: None

High-Risk Share (Women)

RetEmployee · Representation

VAR __a = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[gender] = "Female")) RETURN IF(__a >= 10, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[riskBand] = "High"), KEEPFILTERS(RetEmployee[gender] = "Female")), __a), BLANK())

Direct dependencies: None

High-Risk, High-Impact

RetEmployee · Retention Risk

CALCULATE(COUNTROWS(RetEmployee), FILTER(RetEmployee, RetEmployee[riskBand] = "High" && RetEmployee[impactBand] = "High impact"))

Direct dependencies: None