Forum Discussion

dmbd1904's avatar
dmbd1904
Icon for Helper III rankHelper III
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    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.
      

     

dmbd1904's avatar
dmbd1904
Icon for Helper III rankHelper III
6 years ago

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

dmbd1904 - Try

Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(__Calc<0,0,__Calc)