Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix visual

If my matrix visuals has certain columns that do not have values, then how do I show them as zero?   Thank You!
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    In your calculated measure/ column formula. Just add +0 in the end.

     

    Thanks
    Raj

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous

     

     I think you are pulling ID from table and setting count in the "Fields" Tab. Instead, i would recommend to create a measure COUNT(Table1[ID]) +0 and use it in the matrix , which is the best practice so that it will help you in any futue measure branching as well.

     

    Thanks
    Raj

Anonymous's avatar
Anonymous
Not applicable
7 years ago

In your calculated measure/ column formula. Just add +0 in the end.

 

Thanks
Raj

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous Hey that worked for the measures. But how can I show them with I have taken say Count of ID'S directly from the table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous

     

     I think you are pulling ID from table and setting count in the "Fields" Tab. Instead, i would recommend to create a measure COUNT(Table1[ID]) +0 and use it in the matrix , which is the best practice so that it will help you in any futue measure branching as well.

     

    Thanks
    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous It worked. Thank you!