What it measures
% of employees leaving per year
Business impact
- A high 'chaos tax' from constant recruitment, onboarding, and supervision of new staff, diverting line managers from process improvement to basic training and firefighting.
- Degraded operational performance as inexperienced teams cause more minor stops, higher material giveaway, and more frequent picking errors, directly impacting labor or line capacity.
Formula
(Departures / Average headcount) x 100Grain
One row per employee per month — employee × site × plant × cost centre × period
People & Safety
Inside the Implementation Pack
A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.
50+DAX measures
6dimension tables
8report pages
5,000row demo dataset
The real DAX measure
This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Employee_Snapshot.
Data you need
Fact_Employee_Snapshot— 8 mandatory columns — site key, employee key, ...Dim_Cost_Center— key + nameDim_Employee— key + nameDim_Period— key + nameDim_Plant— key + nameDim_Site— key + nameDim_Date— Auto-generated calendar table — no customer data required
Full field-by-field data contract, in 4 SQL dialects (SQL Server, Snowflake, Databricks, BigQuery), ships in the pack.
Editable thresholds
| Target | 0.15 — performance considered compliant at or below this line |
| Warning | 0.275 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
People & Safety
$149
Everything you need to build Total Employee Turnover Rate in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.