Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Discrepancy between measure and data view

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?

1 Reply