Forum Discussion
Helper IIIBlanks as Nulls in Matrix
Hi I'm trying to convert blank values in my matrix to Zero's. The table looks as follows:
I tried to create another measure as
Adding +0 to the end of your measure is one quick way to fix this
Forecast = CALCULATE(DISTINCTCOUNT(Task[UniqueTaskID]))+0Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 Replies
dmbd1904- amitchandak
Super User
- dmbd1904
Hi amitchandak , I'm not sure I understand but is that what's causing the problem? Is there anyway to avoid the problem?
- Greg_Deckler
Community Champion
dmbd1904 - Generally that is:
Measure = VAR __Calc = <some calculation> RETURN IF(ISBLANK(__Calc),0,__Calc)- dmbd1904
Hi Greg_Deckler , i tried that and got the same problem. See the image in my reply (It wouldn't let me include in the original post)
- Greg_Deckler
dmbd1904 - Try
Measure = VAR __Calc = <some calculation> RETURN IF(__Calc<0,0,__Calc)
Adding +0 to the end of your measure is one quick way to fix this
Forecast = CALCULATE(DISTINCTCOUNT(Task[UniqueTaskID]))+0Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
