What it measures
% of scheduled time lost to unplanned stoppages
Business impact
- Triggers a 'chaos tax' of premium freight to meet delivery windows, overtime labor to catch up on production, and emergency call-out fees for specialist maintenance technicians.
Formula
(Unplanned downtime hours / Scheduled hours) x 100Grain
One row per production line per shift per run
Manufacturing & Operations
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
30,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_Production_Line_Run.
Data you need
Fact_Production_Line_Run— 8 mandatory columns — work center key, plant key, ...Dim_Plant— key + nameDim_Product— key + nameDim_Production_Line— key + nameDim_Shift— key + nameDim_Work_Center— 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.02 — performance considered compliant at or below this line |
| Warning | 0.05 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
Manufacturing & Operations
$149
Everything you need to build Unplanned Downtime % in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.