Forum Discussion

Oomsen's avatar
Oomsen
Icon for Helper III rankHelper III
7 years ago
Solved

Measure delivery on time

I would like to create a measure which gives me a % deliveries on time.   My data: Order                Planned                 Delivered                 Differences 60004                29-01-20...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
Oomsen
Icon for Helper III rankHelper III
7 years ago

Thank you for the respons. 

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