Forum Discussion

calgary_raptor's avatar
calgary_raptor
Frequent Visitor
8 years ago

Display zero instead of blank in matrix table

I have a situation where users enter data on a form and one of the values they selectare dependent on an asset area and a date. When displaying this information in a matrix table I want to display a ...
Need Help
Show and Tell
mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
8 years ago

Add + 0 to the end of your measure. 

  • calgary_raptor's avatar
    calgary_raptor
    Frequent Visitor
    8 years ago

    Great suggestion! I did this but unfortunately it did nothing...

     

    TEST = IF(ISBLANK(sum('Combined'[Values])),0,sum('Combined'[Values])) + 0

     

     

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      That is strange.  The IF(),ISBLANK() should work.  Share the link from where i can download your file.