IF Statement

Question

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 Answer

Hi&nbsp;LewisH,
&nbsp;
Please try this:
Supplier&nbsp;Performance&nbsp;Orig.&nbsp;Expected&nbsp;Percentage&nbsp;OnTime&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;'Purchase&nbsp;Lines'[Supplier&nbsp;Performance&nbsp;Orig.&nbsp;Expected&nbsp;Total&nbsp;OnTime]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;(&nbsp;'Purchase&nbsp;Lines'[Supplier&nbsp;Performance&nbsp;Orig.&nbsp;Expected&nbsp;Total&nbsp;OnTime]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;'Purchase&nbsp;Lines'[Supplier&nbsp;Performance&nbsp;Orig.&nbsp;Expected&nbsp;Total&nbsp;Late]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;100)&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;0
&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

IF Statement

1 Reply

Related content

OR Statement ?

SQL Statement opcion error

Support for MERGE statement

New Column with IF STATEMENT

IF Statement using Power Query