Blanks as Nulls in Matrix

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.

Need Help

Anonymous
6 years ago
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.

Forum Discussion

Blanks as Nulls in Matrix