Measure delivery on time

[Oomsen]

I would like to create a measure which gives me a % deliveries on time.

My data:

Order                Planned                 Delivered                 Differences

60004                29-01-2019           18-01-2019              -11

60005                22-01-2019           22-01-2019             0 

60006                12-02-2019           14-02-2019             2

60007                01-03-2019           15-03-2019             14

My expectation is that 25% is delivered to early, 25% on time and 50% to late. 

Extra detail is that ordernumber and planned date are from the same table but delivered date is from a different table. 

[v-cherch-msft]

Hi @Oomsen 

You may try below measures:

early =
COUNTROWS ( FILTER ( Table1, [Differences] < 0 ) )
    / COUNTROWS ( Table1 )

On time =
COUNTROWS ( FILTER ( Table1, [Differences] = 0 ) )
    / COUNTROWS ( Table1 )

late =
COUNTROWS ( FILTER ( Table1, [Differences] >0 ) )
    / COUNTROWS ( Table1 )

Regards,

[Oomsen]

[Differences] is a measure so this doesn't work unfortunately. 

[v-cherch-msft · Accepted solution]

Hi @Oomsen 

Based on my test,my formula could work.Could you show some screenshot or more details so that we could help further on it?

Regards,

[Mariusz]

Hi @Oomsen 

You can use the expresion below.

YourMeasure = 
DIVIDE(
    CALCULATE(
        COUNT(YourTable[Order]),
        YourTable[Differences] = 0
    ),
    COUNT(YourTable[Order])
)

Hope this helps
Mariusz

[Oomsen]

Thank you for the respons. 

It doesn't work. Maybe because "YourTable[Differences]" is a measure in my report.