What it measures
% of suppliers signed up to CoC requirements
Business impact
- A 1% drop in compliance on a key commodity like certified palm oil forces product reformulation or repackaging, costing 0.2-0.5% of the affected product line's revenue in write-offs and operational disruption — felt first by the Brand Manager pulling product.
- Increased 'compliance chaos tax': emergency sourcing of compliant materials at premium prices, legal fees for reviewing supplier contracts, and management time spent responding to retailer and regulator queries.
- A single non-compliant supplier for a certified ingredient forces a quarantine of all finished goods containing that material. This creates a phantom inventory position and a direct P&L charge for the resulting write-off.
- Failure to provide chain-of-custody evidence during a retailer audit triggers immediate product withdrawal and a formal supplier review — the structured path to delisting.
Formula
(CoC-compliant suppliers / Total suppliers) x 100Grain
One row per supplier per category per period
Procurement & Sourcing
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
5dimension tables
7report pages
5,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_Supplier_Spend_Snapshot.
Data you need
Fact_Supplier_Spend_Snapshot— 6 mandatory columns — supplier key, plant key, ...Dim_Commodity— key + nameDim_Period— key + nameDim_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.
Editable thresholds
| Target | 0.95 — performance considered compliant at or above this line |
| Warning | 0.78 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
Procurement & Sourcing
$149
Everything you need to build Supplier Code of Conduct Compliance in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.