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
It has taken me 3 days already trying to figure out how to show the correct total of measures used in a matrix. Explanations given on the forum seem to be to specific to the cases in question, barely transferable.
If some people benefit form a total that doesn't correspond to the values, I absolutely respect that but why there is no choice?
With this issue I cannot see how users looking for quick ad-chock reports (business people, not code writers) can benefit from this tool.
RE: Matrix totals only as sum of values
there should at least be an option to have the total show the sum of the rows instead of having to do weird DAX-things. This is an annoyance and causes Power BI to be difficult to people who start using it.
I've worked with Qlik products before. No issue there. They have an option to choose between the calculation or sum (and even min, max and average) of the rows.
RE: Matrix totals only as sum of values
Crazy that this is even an issue tbh!
RE: Matrix totals only as sum of values
PLEASE FIX!
RE: Matrix totals only as sum of values
Matrix Totals should always represent sum of row or columns values. No other reason why it should not. Should not have to program a workaround to obtain correct row and columns totals on a Matrix.
RE: Matrix totals only as sum of values
Please, fix this!
RE: Matrix totals only as sum of values
Please please can this be resolved. I cannot think of a circumstance when it would be appropriate for the sum of a row to not equal the sum of a row. This is a bug, and is causing problems. Please can this be fixed.
RE: Matrix totals only as sum of values
This is a BUG Power BI Team!!! There is no circumstance that I can think of where I'd want your default SUM total on the row values of a table or matrix to be anything other than the simple SUM of the ROW values. Why is that so hard? Having to try to workaround this with a DAX formula is an embarrassment to Power BI as a mature data analysis tool and embarrassing to me as I have no good answer for my clients.
RE: Matrix totals only as sum of values
This has to be fixed
RE: Matrix totals only as sum of values
Please fix this.. This is a big issue. For any insights driven organization, this can cause a lot o issue. We make decision based on our data. This issue will slow down the adoption of Power BI.. Thanks