on 01 Dec 2016 22:38:36
It can be readily demonstrated that, for example, a displayed row total is not always the sum of displayed row values. There can be no justification for this. An example of this behavior is available on request.
- Comments (32)
RE: Matrix totals only as sum of values
Please fix this. I am using a matrix visual on a drill through target page and the column total is not correct. However an Excel Pivot table shows correct values
RE: Matrix totals only as sum of values
This has to be fixed
RE: Matrix totals only as sum of values
It happened to for me as well in table totals and subtotals have incorrect calculation.
RE: Matrix totals only as sum of values
Wait, how is this still an outstanding issue from 2016?
Microsoft, can you please correct how the total is calculated for the Matrix & Tables Visualizations. Please, having accurate numbers is essential for reporting....
RE: Matrix totals only as sum of values
Happens in both table and matrix visuals, totals and subtotals have incorrect calculation.
RE: Matrix totals only as sum of values
Why does this happen, Is there a reasonable explanation for it? How can we work around this? Is there any point in using a tool if the results are showing incorrectly. I've spent so long thinking my model was incorrect and changing it until i came across this on the web.
RE: Matrix totals only as sum of values
Please give an option to display the total result of the formula or the sum of the row values!
RE: Matrix totals only as sum of values
it's too misleading, now not sure if I need to go back verify every detail in a very complicated model
RE: Matrix totals only as sum of values
Measure isn't giving total correctly(out of expectation)
RE: Matrix totals only as sum of values
Bad idea... completely misses the core principles of DAX.