Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Since this looks to be a single-table model, you might be experiencing the bug that's called "auto-exist." Do yourself a big favour and refactor your model so that it adheres to Best Practices (meaning: star schema). If you want know why one-table models are BAD, BAD, BAD, you can go to this post: Why one-table models will produce WRONG NUMBERS - Microsoft Power BI Community
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |