Blanks as Nulls in Matrix

[dmbd1904]

Hi I'm trying to convert blank values in my matrix to Zero's. The table looks as follows:

Forecast = CALCULATE(DISTINCTCOUNT(Task[UniqueTaskID]))

I tried to create another measure as 

Forecast in Period = IF(ISBLANK([Forecast]),0,[Forecast])

but this returns the folowing tables with Rows repeated for some reason - It seems it's take Row names from other projects which have been filtered out.

[Anonymous · Accepted solution]

@dmbd1904 

Adding +0 to the end of your measure is one quick way to fix this

Forecast = CALCULATE(DISTINCTCOUNT(Task[UniqueTaskID]))+0

Paul 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.
  

[Greg_Deckler]

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

[dmbd1904]

No unfortunately that didn't work either

[Greg_Deckler]

@dmbd1904 Can you post sample data as text that replicates this issue so I can mock it up?

[dmbd1904]

[amitchandak]

@dmbd1904 , typically this creates a left join and you start getting all values.

[dmbd1904]

Hi @amitchandak , I'm not sure I understand but is that what's causing the problem? Is there anyway to avoid the problem?