How to show zeroes in a matrix when there is no data for particulat row,column combination

[Anonymous]

Hi Team,

In my matrix for few combination of row and columns I do not have data in my table. In such case I m getting BLANK.I want to show zero instead of BLANK. Can you please provide inputs on how this can be achieved. 

I tried with using different DAX function but not able to achieve.

Screenshot of scenario attached herewith.

Thanks!

[jrmoore]

Couple of ways to accomplish this. If those columns showing blank are Measures, just add a +0 to the end of your DAX Measure. If those columns are part of a specific table, then just go into the query editor and replace all null values with a zero for each of your columns that are showing zero.

Thanks

Jarrett