Forum Discussion
items with no value still showing up
I am looking at sales data, each line item in data table is a product with a category. When I look at 2020 vs 2019 it still pulls in old categories that have not been sold since 2018 so I have all th...
I have a matrix with category in the rows and then measures in the values. It is filted on 2020 and my measures are like this:
current year=sum(net sales)
last year=IF (HASONEVALUE ( '4-4-5 Calendar'[4-4-5 Year] ),CALCULATE (SUM (net sales),FILTER (ALL ( '4-4-5 Calendar' ),'4-4-5 Calendar'[4-4-5 Year] = VALUES ( '4-4-5 Calendar'[4-4-5 Year] ) - 1&& CONTAINS(VALUES ( '4-4-5 Calendar'[DayOfYear] ),'4-4-5 Calendar'[DayOfYear],'4-4-5 Calendar'[DayOfYear] ))),BLANK ())
Because I am using a retail calendar. All my data flows correctly but if I scroll down on my chart i have all these categories with no data.