Alternative way to display all columns in a Matrix?

[PBIUWO]

Background: 

I have a report where there is a Matrix and a filter. 

Within the Matrix, there are items on the rows, and Month/Year on the columns. The values are the sales per month.  

*The data source will only show the previous 12 months. 

The filter is used to filter the Item codes that are on the rows. 

For some items, they do not have any sales for each month, so the columns would skip the months that have 0 sales. 

Question:

Without using "Show Items WIth No Data", how can I display the months for that have 0 sales? 

(I can't use Show items with no data, because it causes the visual to show the no memory error)

*would I just have to place a 0 for all of the sales are blank? 

[v-xulin-mstf · Accepted solution]

Hi @PBIUWO

You can try measure like:

Measure = 
CALCULATE(
    SUM('Table'[sales])+0,
    'Table'
)

Best Regards,

Link 

[negi007]

@PBIUWO  i guess you will have to use show items with no data value in this case. else you will have to have one zero record against months where there is no sale volume.