Incorrect Matrix Row Totals

Question

There are lots of posts about this, but they all seem to involve measures.&nbsp;I have a single dataset, no measures, relationships, etc.&nbsp;Throw the data in the matrix and 1 + 1 = 1,&nbsp; &nbsp; &nbsp;12 + 2 = 12, etc.In this case I DO filter by columns, but I would expect that the totals should still add up&nbsp;I should get&nbsp;Part&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;LocA Qty&nbsp; &nbsp;&nbsp; Loc B Qty&nbsp; &nbsp;&nbsp; Totalabc&nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14&nbsp;instead I get&nbsp;Part&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;LocA Qty&nbsp; &nbsp;&nbsp; Loc B Qty&nbsp; &nbsp;&nbsp; Totalabc&nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12&nbsp;Someone&nbsp; mentioned averaging, but that would be an exceptionally retarded thing for PBi to do.&nbsp;Again, NO MEASURES in this dataset. Filtered on Columns.&nbsp;&nbsp;Ideas?&nbsp;&nbsp;&nbsp;

alex_sawdo · Answer

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.

Forum Discussion

Incorrect Matrix Row Totals

1 Reply

Related content

Matrix Totals Incorrect

Incorrect turnover total

Incorrect Column Totals in Matrix showing

Incorrect Total in Matrix Visual

Matrix period showing incorrect total when using previous year measure