🚀 Power BI DAX On-Time Delivery Rate – Long Way vs. True One-Liner! #PowerBI #DAX #OnTimeDelivery

This measure calculates the on-time delivery rate, representing the percentage of orders that ship on or before their promised delivery date. It’s a key performance indicator for operational efficiency in supply chain and customer service dashboards. Here we present two approaches that achieve the same result but differ in structure and readability:

Long Way Approach:

Step-by-Step Logic:

First, the measure calculates the number of orders delivered on time using a variable (OnTimeCount). This variable uses the CALCULATE function to filter the Orders table where the actual shipping date (ShipDate) is less than or equal to the promised date (PromisedDate).

Next, it computes the total number of orders (TotalOrders) by counting all rows in the Orders table.

Finally, the measure returns the on-time delivery rate by dividing the on-time count by the total orders using the DIVIDE function. The DIVIDE function is used to safeguard against division by zero by returning 0 if no orders exist.

Advantages:

Clarity: Breaking down the calculation into variables makes the logic transparent. Each part of the calculation is isolated, which makes it easier to understand and debug.

Educational: Ideal for students and new DAX users who benefit from seeing intermediate steps.

True One-Liner Shortcut:

Compact Expression:

This version nests the entire calculation within a single DIVIDE function. It directly calculates the on-time orders count by applying the filter inside CALCULATE and divides that result by the total order count.

Advantages:

Brevity: The measure is highly concise, reducing code clutter. This is perfect for experienced users who value compactness and minimalism.

Efficiency: With no intermediate variables, the one-liner is streamlined for production models where succinct expressions are preferred.

Key Differences:

The Long Way emphasizes readability and step-by-step breakdown. It is excellent for learning, documentation, and troubleshooting.

The True One-Liner offers a sleek, minimalistic alternative that achieves the same outcome with less code, making it ideal for seasoned developers who are comfortable with nested functions.

Both methods rely on similar functions—CALCULATE, COUNTROWS, and DIVIDE—but the choice between them depends on whether you prioritize transparency or compactness in your DAX code.

#PowerBI #DAX #OnTimeDelivery #BusinessIntelligence #DataAnalysis