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!
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!
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
371 | |
101 | |
65 | |
55 | |
43 |
User | Count |
---|---|
364 | |
115 | |
79 | |
65 | |
53 |