DAX divide issue

[Cime14]

Hi all,

how could I correct the formula in power pivot measures to get value 0% where numerator and denominator are both 0?
I was able to resolve this issue where only denominator is 0 but I am lost when both are.

My current formula:
=DIVIDE(CALCULATE(SUM(SAP_Final[MTD]));CALCULATE(SUM(FCRS_PM[MTD]));1)-1

Would appreciate your help!

Have a nice day!

 

[Cime14]

@pjmorris Thanks a lot!! You solved it!!
I used =IF(AND(SUM(SAP_Final[MTD])=0, SUM(FCRS_PM[MTD])=0), 0, DIVIDE(SUM(SAP_Final[MTD]), SUM(FCRS_PM[MTD]), 1)-1) and got what I wanted!

Many thanks to both!

 

[pjmorris]

excellent, delighted to have helped.