Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous what are your measures and how you are visualizing it? Maybe it is trying to show 2019 vs 2018 the way you are trying to visualize the data. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

     
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago