Matrix visual

[Anonymous]

If my matrix visuals has certain columns that do not have values, then how do I show them as zero?

Thank You!

[Anonymous · Accepted solution]

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

Thanks
Raj

[Anonymous]

Use Column+0 in formula.

Thanks
Raj

[Anonymous]

@Anonymous Hey where to give that?

[Anonymous · Accepted solution]

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

Thanks
Raj

[Anonymous]

@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 · Accepted solution]

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]

@Anonymous It worked. Thank you!