What it measures
% of supplier quality issues with formal corrective action
it measures the formal response after a supplier quality failure has already occurred, potentially stopping a production line or requiring a batch quarantine. The operational damage is already done before the KPI is calculated.
Business impact
- Increased 'chaos tax' from unaddressed supplier issues: unplanned line-side sorting, extra QC sample testing, and production schedule changes to accommodate faulty materials.
- Distorted inventory position, with a higher percentage of stock in batch quarantine or on QA hold pending disposition, creating phantom availability and risking customer service commitment.
- When a retailer audit finds unaddressed supplier non-conformances in your system, it triggers an immediate supplier performance review and places your account on a path to delisting.
Formula
(Issues with SCAR / Total supplier quality issues) x 100Grain
One row per non-conformance record / CAPA — supplier × material × plant × 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— 7 mandatory columns — material key, scar indicator, ...Dim_Employee— key + nameDim_Material— material_key + material_descriptionDim_Plant— 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 Supplier Quality Corrective Action Rate in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.