I am trying to build a delivery report and I would like to count the # of orders delivered On Time/TooLate/Not Delivered.
My issue is that for a same Order ID I sometimes have different Delivery Status, when some items were not available for example.
See the example below :
In this case I would like to consider the order as part of the ‘‘Not Delivered’’ ones even if some items have been delivered “On Time”.
I am really struggling to find the best approach ? Or what DAX functions would be helpful ?
Thanks a lot in advance