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])
Solved! Go to 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
)
Proud to be a Super User!
Could you try OHASum = IF(HASONEVALUE(SUM(OHA_[Total]));0)?
getting the following error
this will work
OHASum = SUM(OHA_[Total])+0
the issue may be that you will see more items that you would normally like
Proud to be a Super User!
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.
Hi Stachu
Apologies but no working that data set in the table increase to show unwanted elements.....still not getting the desireed result
My bad, the if-formula is not complete.
OHASum = IF(HASONEVALUE(SUM(OHA_[Total]);SUM(OHA_[Total]);0)
i have chnaged the ; to , and still getting error to many values passed to the HASONEVALUE function
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
)
Proud to be a Super User!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
65 | |
51 | |
51 |
User | Count |
---|---|
184 | |
104 | |
82 | |
79 | |
78 |