Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

IF Blank then 0

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
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    AllanBerces Try using

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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

AllanBerces Try using

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

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago

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