Forum Discussion
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 c...
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