Request DAX Help - Percent of Orders with Delivery Date Changes

[etane]

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!

[etane]

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

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.