Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Retention and Composition

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 — 4 Turnover cost

Selected page

4 Turnover cost

DAX definitions

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

Cost per Exit

RetEmployee · Turnover Cost

DIVIDE([Replacement Cost (Exits)], [Exits (TTM)])

Direct dependencies: Replacement Cost (Exits), Exits (TTM)

Exits (TTM)

RetEmployee · Headcount & Flow

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

Direct dependencies: None

Payroll Base (Active)

RetEmployee · Turnover Cost

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

Direct dependencies: None

Regretted Replacement Cost

RetEmployee · Turnover Cost

CALCULATE(SUM(RetEmployee[replacementCostUsd]), KEEPFILTERS(RetEmployee[regretted] = "Yes"))

Direct dependencies: None

Replacement Cost % of Payroll

RetEmployee · Turnover Cost

DIVIDE([Replacement Cost (Exits)], [Payroll Base (Active)])

Direct dependencies: Replacement Cost (Exits), Payroll Base (Active)

Replacement Cost (Exits)

RetEmployee · Turnover Cost

SUM(RetEmployee[replacementCostUsd])

Direct dependencies: None