What it measures
% of Critical Control Point checks within limits
The KPI measures a food safety failure after it has occurred. The moment a CCP check is out of limits, the product is non-conforming and must be placed on hold, locking in the operational consequence before the score is even calculated.
Business impact
- A single 0.01% failure on one CCP check triggers a mandatory batch quarantine, investigation, and potential product write-off that can cost $50k-$250k overnight — felt first by the Plant Controller who must provision for the loss.
- Increased 'chaos tax' from CCP deviations: unplanned downtime for investigation, QA and lab overtime for root cause analysis, and logistics costs for managing quarantined stock.
- A CCP failure legally converts sellable finished goods into a zero-value inventory position. The entire affected batch is moved to QA-held status, creating a hold-release delay that directly impacts the ability to meet customer service commitments.
- Any systemic pattern of CCP failures, or one failure resulting in a market withdrawal, triggers an immediate, unannounced retailer audit and places the entire account on a formal remediation notice — the final step before delisting.
Formula
(Passed CCP checks / Total CCP checks) x 100Grain
One row per CCP check event — CCP × production line × plant × batch × shift × employee × 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_HACCP_CCP_Check.
Fact_HACCP_CCP_Check— 9 mandatory columns — ccp check count, production line key, ...Dim_Batch— batch_key + batch_nbrDim_CCP— key + nameDim_Employee— key + nameDim_Plant— key + nameDim_Production_Line— key + nameDim_Shift— 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 | 1 — performance considered compliant at or above this line |
| Warning | 0.999 — 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 HACCP CCP Compliance Rate in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.