What it measures
% of corrective actions closed within agreed timeline
The KPI measures the response to a failure that has already occurred (e.g., audit finding, customer complaint). It is a backward-looking measure of problem-solving discipline, not a predictor of the initial failure.
Business impact
- Increased 'chaos tax' from recurring failures: unplanned line stoppages for rework, QA-held stock tying up warehouse space, and quality team overtime spent chasing overdue actions instead of preventing new issues.
- Delayed CAPAs on recurring process failures (e.g., packaging seal integrity) generate a steady stream of non-conforming stock, bloating the inventory position of QA-held product and increasing write-off risk.
- Failure to close a single CAPA from a major retailer audit within the agreed timeline moves a supplier to a formal service review — the final structured warning before delisting.
Formula
(CAPAs closed on time / Total CAPAs) x 100Grain
One row per non-conformance record / CAPA — plant × supplier × material × 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_NonConformance_CAPA. It guards against missing dates and values with NOT ISBLANK checks.
Fact_NonConformance_CAPA— 9 mandatory columns — employee key, task count, ...Dim_Employee— key + nameDim_Material— material_key + material_descriptionDim_Plant— key + nameDim_Production_Line— 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.85 — 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 CAPA On-Time Completion Rate in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.