Calculating Difference of Dates and KPI visual of % in time

[pcda]

Hi everyone! I'm having a bit of a problem displaying a visual of a percentage of on-time deliveries. I have 2 columns: Estimated Delivery Date and Real Delivery Date. If Real Delivery Late < Estimated Delivery Date, then the delivery was done on time. 

Then, the total deliveries in time divided by total deliveries should be equal to the % of On-Time Deliveries and I should be able to place that in a Card visual. 

I tried using a meassure with DATEDIFF and then another one with an IF, but it is not counting as I expect it to. Anyone knows a workaround for this? 

The table looks like this: 

Estimated Delivery	Real Delivery
10/08/2022	07/08/2022
11/08/2022	10/02/2022
12/08/2022	25/10/2022
13/08/2022	31/07/2022
14/08/2022	28/08/2022
15/08/2022	15/08/2022
16/08/2022	16/09/2022

For this example, the visual should display "43%". 

Thank you very much!

[pcda]

Thank you @parry2k ! Worked like a charm

[parry2k · Accepted solution]

@pcda this is what I will do, first add a column to flag if delivery is on time or late and then add a measure to show in the visual

Delivery Status Column = 
IF ( Table[Real Delivery Date] < Table[Estimate Delivery Date], "OnTime", "Late" )

Count Measure = COUNTROWS ( Table )

On Time % Measure = 
DIVIDE ( 
    CALCULATE ( [Count Measure], Table[Delivery Status Column] = "OnTime" ),
    CALCULATE ( [Count Measure], ALL () )
)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.