Need help with measure calulation with NaN to convert to Zero

[Anonymous]

All

I need help with trying to convert my measure calulation results from NaN to zero. I've reviewed the post in the community but need help with my formula for the If Then statement below:.

XYZPPM = CALCULATE(SUM(CQMS_SUPPLIER_PPM_DATA_V[JANREJ_NUM]) / CALCULATE(SUM(CQMS_SUPPLIER_PPM_DATA_V[JANREC])) * 1000000)

[Anonymous · Accepted solution]

Look into using the DIVIDE Function instead of "/"

https://docs.microsoft.com/en-us/dax/divide-function-dax