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
I agree this is very frustrating and not what I was expecting as the default for totals in a matrix
RE: Matrix totals only as sum of values
I agree, very frustrating that in the matrix when using measures they don't add up correctly on row totals or columns totals and not to mentioned grand totals... I cannot imagine a scenario were this outcome would be correct...it reduces the value of a great tool...
RE: Matrix totals only as sum of values
I don't think this is an error. A good example of this is distinct counts. If you have rows per store, and the metric is distinct counts of customers visiting, when you total the distinct will apply to the total. So if a customer went to 2 stores, you would see 1+1 in the rows, but in the total it would show as 1 which is correct. So you need to either change to an absolute count, or break apart the total into a different visual to make it clear its a different metric (customers in the organization).
RE: Matrix totals only as sum of values
I can't believe you can't do this, surely this should be a critical feature
RE: Matrix totals only as sum of values
I agree that this should be an option, but there are certainly many times that you do not want the total to be the sum of the parts (e.g. when the measure is an average).
RE: Matrix totals only as sum of values
Or please explain with examples when you believe the current behavior is useful, because I can't think of any situation where it is
RE: Matrix totals only as sum of values
There should be an option definately to either show the total of the rows above, OR show in the total field the measure as evaluated in its context. That way you can finally sum up measures in matrices reliably
RE: Matrix totals only as sum of values
This is very annoying: in Qlik View there is a very simple option to show in the total the result of the formula or the sum of the row values! Please solve this issue asap!!!
RE: Matrix totals only as sum of values
This is ridiculous - there are people in my organization that are starting to refuse to use Power BI because of this issue alone...
RE: Matrix totals only as sum of values
Please resolve this issue, there is really no reason for it not to be a sum in a visual like this.