IF Statement

[LewisH]

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 · Accepted solution]

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