Request DAX Help - Percent of Orders with Delivery Date Changes

etane — Thu, 19 Jun 2025 00:38:43 GMT

Hello.

I have a rather unqiue source table that I am having difficulty finding a way to derive the percent of orders with revised delivery date change.

Example of the table below:

This table shows 1 customer with 4 orders. Orders with no change in delivery dates will show either only 1 delivery date like Order 100003 or no delivery date at all like order # 100004. And, orders with delivery date change will have more than 1 row of delivery date like in orders 100001 and 100002.

Based on this data, there's 4 orders and 2 of these orders have at least 1 date change. So, the percent of Customer A's orders with delivery date change is 2 out of 4 or 50%.

And, based on this data, I'd like to create two tables:

1) Detailed by Order. Show the orders count and orders with delivery date change:

2) Summary. Basically, same table as above but just % changed by customer (the data doesn't have Customer B & C's but wanted to illustrate the need to show a customer summary):

Here's a link to the data set loaded to a PBIX file

Link

Thanks!

Re: Request DAX Help - Percent of Orders with Delivery Date Changes

Jihwan_Kim — Thu, 19 Jun 2025 03:14:03 GMT

Hi,

Please check the below picture and the attached pbix file.

Re: Request DAX Help - Percent of Orders with Delivery Date Changes

etane — Thu, 19 Jun 2025 15:47:45 GMT

Jihwan_Kim This is exactly what I am looking for. Thanks!

topic Re: Request DAX Help - Percent of Orders with Delivery Date Changes in DAX Commands and Tips

Request DAX Help - Percent of Orders with Delivery Date Changes

Re: Request DAX Help - Percent of Orders with Delivery Date Changes

Re: Request DAX Help - Percent of Orders with Delivery Date Changes