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]))

3 Replies

  • 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]))

  • mdaatifraza5556's avatar
    mdaatifraza5556
    Icon for Super User rankSuper User
    1 year ago

    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)