Show blank cells as zeros using Sum formula in dax

[Anonymous]

Hi Experts

how would you convert the following sum formula to show '0' in empty/blank cells as opposed to blank...

OHASum = SUM(OHA_[Total])

[SjoerdV]

Could you try OHASum = IF(HASONEVALUE(SUM(OHA_[Total]));0)?

[Anonymous]

getting the following error

[Stachu]

this will work

OHASum = SUM(OHA_[Total])+0

the issue may be that you will see more items that you would normally like

[JustSayJoe]

This displays the 0 value for that particular column using the measure. However, a secondary calculated column that is attempting to subtract that measure from another, still shows a blank value. It doesn't seem to recognize the zero value.

[Anonymous]

Hi Stachu

Apologies but no working that data set in the table increase to show unwanted elements.....still not getting the desireed result

[SjoerdV]

My bad, the if-formula is not complete.

OHASum = IF(HASONEVALUE(SUM(OHA_[Total]);SUM(OHA_[Total]);0)

[Anonymous]

i have chnaged the ; to , and still getting error to many values passed to the HASONEVALUE function

[Stachu · Accepted solution]

well normally blanks wouldn't appear at all unless there is value in other measures
so maybe a conditional such us this would solve it:

OHASum =
VAR OHA =
 SUM ( OHA_[Total] )
RETURN
 IF (
 ISBLANK ( OHA )
 && ( [OtherMeasure1] <> 0
 || [OtherMeasure2] <> 0 ),
 0,
 OHA
 )