Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi @PBIUWO
You can try measure like:
Measure =
CALCULATE(
SUM('Table'[sales])+0,
'Table'
)
Best Regards,
Link
Hi @PBIUWO
You can try measure like:
Measure =
CALCULATE(
SUM('Table'[sales])+0,
'Table'
)
Best Regards,
Link
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |