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 — 7 Parity (screening)

Selected page

7 Parity (screening)

DAX definitions

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

Exit Rate (Majority)

RetEmployee · Parity

VAR __n = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[ethnicityRollup] = "Majority (White)")) RETURN IF(__n >= 5, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Terminated"), KEEPFILTERS(RetEmployee[ethnicityRollup] = "Majority (White)")), __n), BLANK())

Direct dependencies: None

Exit Rate (Men)

RetEmployee · Parity

VAR __n = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[gender] = "Male")) RETURN IF(__n >= 5, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Terminated"), KEEPFILTERS(RetEmployee[gender] = "Male")), __n), BLANK())

Direct dependencies: None

Exit Rate (Non-majority)

RetEmployee · Parity

VAR __n = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[ethnicityRollup] = "Non-majority (all other)")) RETURN IF(__n >= 5, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Terminated"), KEEPFILTERS(RetEmployee[ethnicityRollup] = "Non-majority (all other)")), __n), BLANK())

Direct dependencies: None

Exit Rate (Women)

RetEmployee · Parity

VAR __n = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[gender] = "Female")) RETURN IF(__n >= 5, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Terminated"), KEEPFILTERS(RetEmployee[gender] = "Female")), __n), BLANK())

Direct dependencies: None

Exit Rate Ratio (Non-majority ÷ Majority)

RetEmployee · Parity

DIVIDE([Exit Rate (Non-majority)], [Exit Rate (Majority)])

Direct dependencies: Exit Rate (Non-majority), Exit Rate (Majority)

Exit Rate Ratio (Women ÷ Men)

RetEmployee · Parity

DIVIDE([Exit Rate (Women)], [Exit Rate (Men)])

Direct dependencies: Exit Rate (Women), Exit Rate (Men)

Promotion Rate (Men)

RetEmployee · Parity

VAR __a = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[gender] = "Male")) RETURN IF(__a > 5, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[gender] = "Male"), KEEPFILTERS(RetEmployee[recentPromo] = "Yes")), __a), BLANK())

Direct dependencies: None

Promotion Rate (Women)

RetEmployee · Parity

VAR __a = CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[gender] = "Female")) RETURN IF(__a > 5, DIVIDE(CALCULATE(COUNTROWS(RetEmployee), KEEPFILTERS(RetEmployee[status] = "Active"), KEEPFILTERS(RetEmployee[gender] = "Female"), KEEPFILTERS(RetEmployee[recentPromo] = "Yes")), __a), BLANK())

Direct dependencies: None

Promotion Rate Ratio (Women ÷ Men)

RetEmployee · Parity

DIVIDE([Promotion Rate (Women)], [Promotion Rate (Men)])

Direct dependencies: Promotion Rate (Women), Promotion Rate (Men)