Forum Discussion
Incorrect Matrix Row Totals
There are lots of posts about this, but they all seem to involve measures. I have a single dataset, no measures, relationships, etc. Throw the data in the matrix and 1 + 1 = 1, 12 + 2 = 1...
It could be that instead of doing a COUNT, Power BI is doing a DISTINCTCOUNT which would lead to the totals being different. Is it possible that in the example Part abc can exist in both LocA and LocB?
Also, no need for hostility towards the software or when asking for assistance. Measures are an incredibly powerful tool, and could solve this issue for you as well.