Sales by week without blanks in Matrix - no measure?

[Anonymous]

Hi all, I have a Matrix that presents sales areas in the rows and week numbers in the columns and values are the counts of sales. This gives a nice table of sales by week. However there are blanks instead of zeros where I would like zeros if no sales.

I have looked at a lot of solutions on here that seem to refer to 'adapting measures' - however my table is very simple, it doesn't involve measures or anything. I just have the sales table that updates each day and date is linked to date in a calendar table I've created.

Can anyone help with a simple solution to this? Below is an example of how the table looks now and what I've put in to the visualisation if it helps? Thank you!

[Anonymous]

Thanks that's great.

[Greg_Deckler · Accepted solution]

@Anonymous Create a simple measure like this:

Measure = COUNT('Table'[Priority Group]) + 0

You put that in your Values area instead of the column.