Forum Discussion
Different Totals for same data in Matrix vs. Column chart
I am calculating distinct orders with certain type of vouchers and experiencing different Totals in Matrix and Column chart.
See attached picture please.
It looks like Total performs distinct count of orders without filter context of vouchers type for matrix and simple sum of values for column chart total.
Both ways are somehow logic but I dont understand why it is not the same.
Do someone experience same "issue"?
Do someone know how calculating of Totals works for different visuals?
thank you
Pavel
3 Replies
PavelHanus This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907thanks Greg_Deckler,
I am aware of articles you posted. I know I can "fix" it but I dint need to.
I just need to understand why same total behave differently in column chart and matrix. Do you have any idea why?PavelHanus Well, the short answer is that Table and Matrix visuals are broken and have been since day 1 with Power BI. As you see, other visuals do not exhibit this behavior so there is no reason that table and matrix visuals could also not display the correct value. I have an Enterprise DNA video on this subject that shows that third-party table and matrix visuals are able to solve this issue. Microsoft just refuses to fix their broken visuals.
