Solved: IF Statement

LewisH · ‎07-13-2018

In the calculation I want it to display 0 if the result is 0 rather than blank

Supplier Performance Orig. Expected Percentage OnTime = CALCULATE('Purchase Lines'[Supplier Performance Orig. Expected Total OnTime] / ('Purchase Lines'[Supplier Performance Orig. Expected Total OnTime] + 'Purchase Lines'[Supplier Performance Orig. Expected Total Late] ) * 100)

Thanks

v-yulgu-msft · ‎07-15-2018

Hi @LewisH,

Please try this:

Supplier Performance Orig. Expected Percentage OnTime =
CALCULATE (
    'Purchase Lines'[Supplier Performance Orig. Expected Total OnTime]
        / ( 'Purchase Lines'[Supplier Performance Orig. Expected Total OnTime]
        + 'Purchase Lines'[Supplier Performance Orig. Expected Total Late] )
        * 100
)
    + 0

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.