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.
      

     

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)
dmbd1904's avatar
dmbd1904
Icon for Helper III rankHelper III
6 years ago

No unfortunately that didn't work either

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

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