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

     

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

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

     

     

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

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