IF Blank then 0

[AllanBerces]

Hi good day, can anyone pls need assistance on my calculated column. If the result is Blank then equal to 0.

Overall = DIVIDE(Daily_%'[Overall_Earned],'Daily_%'[Overall_Total])

Thank you

[mdaatifraza5556]

Hii, @AllanBerces 
Please use the third argument 0 in your DAX.
Below is the corrected DAX

Overall = DIVIDE(Daily_%'[Overall_Earned],'Daily_%'[Overall_Total], 0)

[bhanu_gautam · Accepted solution]

@AllanBerces Try using

DAX
Overall = IF(ISBLANK(DIVIDE(Daily_%'[Overall_Earned], Daily_%'[Overall_Total])), 0, DIVIDE(Daily_%'[Overall_Earned], Daily_%'[Overall_Total]))

[AllanBerces]

Hi @bhanu_gautam thank you very much for the reply, all good