Implementation Packs / Supply Chain

SC-01 · Supply Chain

OTIF (On-Time In-Full)

Monthly ↑ Higher is better Outcome Lagging

OTIF (On-Time In-Full) measures, for each customer order, whether it was delivered on time and in full at customer receipt. The pack breaks this ratio down by customer, site, product family, and channel, with gap-to-target and a 24-month rolling history.

See it live
A real report page from the Implementation Pack, running on the food-industry demo dataset.
OTIF (On-Time In-Full) Implementation Pack
Overview page of the OTIF Implementation Pack report: KPI cards for OTIF, on-time and in-full rates against target, a 12-month trend with target and warning lines, OTIF by temperature class, and the bottom 5 customers and product lines
50+DAX measures
4Dim. tables
6Report pages
50,000Demo rows

What it measures

OTIF (On-Time In-Full) measures, for each customer order, whether it was delivered on time and in full at customer receipt. The pack breaks this ratio down by customer, site, product family, and channel, with gap-to-target and a 24-month rolling history.

Lagging indicator

OTIF measures service failures after delivery; the financial consequence, such as a retailer penalty or lost sale, is already locked in before the score is calculated and reported.

Business impact

  • Increased 'chaos tax' from emergency production runs, premium freight spend, and customer service overtime to manage the fallout of broken delivery promises.
  • Sustained underperformance triggers a formal retailer service improvement plan — the structured final warning before range removal and delisting.

Formula

(Order lines delivered OTIF / Total order lines) x 100

Grain

One row per customer sales order line — customer × product × site × requested delivery date

Supply Chain

Inside the Implementation Pack

A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.

Live interactive preview

The real report, filterable live -- not a screenshot. Runs on the food-industry demo dataset; data export is disabled.

50+DAX measures
4dimension tables
6report pages
50,000row demo dataset
The real DAX measure SC-01 DAX measure from the Implementation Pack

This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Customer_Order_Line. It guards against missing dates and values with NOT ISBLANK checks.

Data you need
  • Fact_Customer_Order_Line — 7 mandatory columns — qty ordered, requested delivery date key, ...
  • Dim_Customer — key + name
  • Dim_Product — key + name
  • Dim_Site — key + name
  • Dim_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
Target0.98 — performance considered compliant at or above this line
Warning0.95 — amber alert — triggers a review

Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.

Supply Chain $149

Everything you need to build OTIF (On-Time In-Full) in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.

Request access

SC-01 — OTIF (On-Time In-Full) · $149 for the full Implementation Pack. Only email is required.