Forum Discussion
Community ChampionToday is...
Super UserStacked column/bar charts? Yes, I definitely use them but not for non-additive measures. Stacked columns/bars aren't really a good choice for non-additive measures.
I tend to have lots of matrix visuals with return measures like ROI or IRR that act more like weighted averages when calculating the total row.
Community ChampionAlexisOlson The point is, measure totals are "correct" in stacked visuals but not in tables and matrixes. It's mind boggling. Either calculate totals the right way or calculate totals the wrong way everywhere. They are both totals of what is in the visual so...
- AlexisOlson
Whether or not they are "correct" depends on what you need to achieve with the report. Depending on what you need, it's possible that the matrix totals are "correct" and the stacked visuals are not. I think the current situation is definitely unintuitive but perhaps an acceptable compromise since stacked visuals are usually used for additive measures whereas matrix visuals aren't as limited conceptually.
If we force the behavior of the totals to be consistent, then I would strongly prefer stacked visual totals to behave like matrix visuals rather than the other way around. I can always use an iterator to force a total to visually aggregate additively. If matrix totals couldn't properly handle non-additive measures, then I literally could not use Power BI for my work, at least not without huge changes to nearly all of my reports in order to work around that severe limitation.
It doesn't have to be just one or the other though. Instead of breaking all non-additive measure totals, add an option on the matrix visual to calculate subtotals by aggregating its components and everyone can have what they need. Such a feature would be nice to have but is more of an enhancement than fixing something "broken".
- Greg_Deckler
AlexisOlson So go vote for the idea then, because that's exactly what it says, provide options for how totals are returned. I have to believe you are an outlier on this. I literally answered 4 measure totals questions today. Every Excel user expects totals to work the right way. It also basically destroys any concept of self-service visualizations because if you have additive measures, you can never guarantee that they will be correct in every situation.
I simply cannot comprehend the attitude "Oh yeah that makes sense for stacked visuals" and then turn around and somehow it does not make sense for table and matrix visuals when I would bet you that 99% of the people on the planet expect a total row in a table to be the sum of the individual rows.
- AlexisOlson
I have voted for the linked one and here are a few other similar ideas:
https://ideas.powerbi.com/ideas/idea/?ideaid=79d5dc4c-2d4a-471a-850c-307908096ac8
https://ideas.powerbi.com/ideas/idea/?ideaid=39200232-13ff-4b84-b687-cdcf538671be
https://ideas.powerbi.com/ideas/idea/?ideaid=10335383-00df-4a1f-a874-2c45e79e3855
https://ideas.powerbi.com/ideas/idea/?ideaid=f6455fc9-f7bd-4d21-ac71-157b1de9c250
https://ideas.powerbi.com/ideas/idea/?ideaid=63a487c4-208b-49f9-acc3-30e246ed2482
Oddly enough, the "Administrator" seems to think this idea is already "COMPLETED":
https://ideas.powerbi.com/ideas/idea/?ideaid=86826f5d-3a26-4737-bc69-28b225b4304d
I haven't found any similar ideas that are popular enough to support the claim that this is as big of a problem as you suggest.
BTW, if you actually have an additive measure, then you'll never have this problem. The only issue is when you have non-additive measures that you expect to aggregate in an additive way.