What it measures
% of total waste diverted from landfill
the rate is calculated from waste transfer notes after waste has been collected and processed, confirming a past operational outcome. It doesn't predict future waste generation.
Business impact
- Increased 'chaos tax' from poor waste management: double-handling of rejected recycling bales, emergency waste collection fees, and management time spent responding to compliance notices.
Formula
(Recycled + Composted) / Total waste x 100Grain
One row per waste disposal event — site × material × disposal method × date
Inside the Implementation Pack
A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.
This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Waste_Disposal.
Fact_Waste_Disposal— 9 mandatory columns — material key, plant key, ...Dim_Material— material_key + material_descriptionDim_Plant— key + nameDim_Production_Line— key + nameDim_Site— key + nameDim_Supplier— 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.
| Target | 0.95 — performance considered compliant at or above this line |
| Warning | 0.8 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
Everything you need to build Waste Diversion Rate in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.