KKPI Formulas
Power BI DAX

Operations DAX Measures

Copy DAX measure examples for common operations KPIs used in Power BI dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

Operations Power BI dashboard books Books that help you understand Operations Power BI dashboard and related business metrics more deeply. Explore resources → Operations Power BI dashboard audiobooks Audiobook searches for learning Operations Power BI dashboard while commuting, walking, or working. Explore resources → Lean Six Sigma resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Supply chain analytics Practical resources for turning Operations Power BI dashboard into reports, dashboards, and business decisions. Explore resources →

Operations KPI DAX examples

OEE
OEE =
[Availability] * [Performance] * [Quality]

Full OEE guide →

Cycle Time
Cycle Time =
DIVIDE(
    [Total Production Time],
    [Units Produced]
)

Full Cycle Time guide →

Throughput
Throughput =
DIVIDE(
    [Units Produced],
    [Time Period]
)

Full Throughput guide →

Capacity Utilization
Capacity Utilization =
DIVIDE(
    [Actual Output],
    [Maximum Possible Output]
)

Full Capacity Utilization guide →

On-Time Delivery
On-Time Delivery =
DIVIDE(
    [Orders Delivered on Time],
    [Total Orders]
)

Full On-Time Delivery guide →

Defect Rate
Defect Rate =
DIVIDE(
    [Defective Units],
    [Total Units]
)

Full Defect Rate guide →

First Pass Yield
First Pass Yield =
DIVIDE(
    [Good Units Without Rework],
    [Total Units]
)

Full First Pass Yield guide →

Scrap Rate
Scrap Rate =
DIVIDE(
    [Scrapped Units],
    [Total Units Produced]
)

Full Scrap Rate guide →

Order Fulfillment Time
Order Fulfillment Time =
DATEDIFF([Order Date], [Delivery Date], DAY)

Full Order Fulfillment Time guide →

Production Efficiency
Production Efficiency =
DIVIDE(
    [Actual Output],
    [Standard Output]
)

Full Production Efficiency guide →

Downtime Rate
Downtime Rate =
DIVIDE(
    [Downtime],
    [Planned Production Time]
)

Full Downtime Rate guide →

Backorder Rate
Backorder Rate =
DIVIDE(
    [Backordered Orders],
    [Total Orders]
)

Full Backorder Rate guide →

Perfect Order Rate
Perfect Order Rate =
DIVIDE(
    [Perfect Orders],
    [Total Orders]
)

Full Perfect Order Rate guide →