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

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?