Delivery indicators classification

Question

Hi there,&nbsp;I have a table with the following values:&nbsp;LatestDateToBeDelivered | ActualDateOfDelivery | LateDeliveryIndicator&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 07/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;26/01/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;What I want to get is classification of these Late Deliveries in a way that I could split them as following: not late = 1, 1-3 days late = 2, 4-7 days late = 3, 8-15 days late = 4 and 15 or more days = 5. For now, I only have first two columns.&nbsp;What I already used, was this, and it worked perfectly -&gt; https://community.powerbi.com/t5/Desktop/Measure-on-time-delivery-performance-and-slice-by-origin/m-p/210013/highlight/true#M92668&nbsp;However, now I would like to say more about it than Late or On-time since being a day or two late is not a big deal, but being late more than a week is an alarm.&nbsp;Anybody had a similar issue?

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
You may add a measure to get LateDeliveryIndicator&gt;=3 or other values like below.Then use it in visual level filter to get the&nbsp;alarm.
Measure = IF([LatestDateToBeDelivered]&gt;=3,1)

Regards,
Cherie

anonymous · Answer

Hi Cherie,&nbsp;Many thanks for your reply and time to explain. However, this solution does not work for me at all. When I try to create a new measure with the formulae you provided, the result I get is ''A single value for column 'LatestDateToBeDelivered' in table 'XY' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count or sum to get a single result."&nbsp;Wouldn't it make more sense to make it similar to your but with the full formula expression where I can say something like this:&nbsp;IF([LatestDateToBeDelivered] &gt;=&nbsp; [ActualDateOfDelivery], &gt;= 3, 1)&nbsp;Sorry for my bad DAX skills, but I would read this if latest date to be delivered is greater or equal to actual date of delivery, for the value of 3, then classify as 1. Does this make sense?

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
You may try below measure with DATEDIFF function.Then use it in filter.
Measure =
IF (
    DATEDIFF (
        SUM ( Table1[LatestDateToBeDelivered] ),
        SUM ( Table1[ActualDateOfDelivery] ),
        DAY
    ) &gt;= 3,
    1
)

Regards,
Cherie

anonymous · Answer

Hi v-cherch-msft&nbsp;,&nbsp;Unfortunately, this does not help either. Although, I did manage to use DATEDIFF function to retrieve some values back in the form I would like them. Many thanks for your help!

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Could you&nbsp;share some data sample and expected output?You can upload the .pbix file to OneDrive and post&nbsp;the link here. Do mask sensitive data before uploading.
&nbsp;
Regards,
Cherie

Forum Discussion

Delivery indicators classification

5 Replies

Related content

Fabric + Purview (Data Classification)

How to count indicators per classification based on the latest date (DAX)

Container Delivery Date

Microsoft data classification and PowerBI

Delivery Truck Efficiency