Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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 1
Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.