I’m trying to count the number of times a product in the category Games was bought in the year 2020.
I have a table Products with a column [number], [date] and [ category]. In this particular case the number is always 1 (i.e. A customer always buys just 1 item) and there are no empty rows. In Data view I have filtered [date] to only show records between 1-1-2020 and 31-12-2020 and [category] to only return the value ‘games’. This returns 448 filtered rows.
I have created a measure for the total number of products sold: Total Number = sum(Products[number]).
Then I created a measure for the total number of Games sold: Total Number Games = Calculate([Total Number] , Products[cateogory] = “games”)
Both measures appear to work just fine.
However, when I plot Total Number Games, I see that there are 253 games sold. When I create a table showing the Total Number Games by Date, I see the same.
I expected a value of 448 since I have 448 rows in my Product table, all filed with the value “1” for [number].
What could be the cause for this discrepancy?
