Forum Discussion
Exclude Certain Subtotals From Matrix
Hi Cmcmahan -- thanks for that. Honestly, my table looks a lot less cluttered without subtotals so I may just exclude them entirely. They should really have an easy feature that lets you pick and choose which subtotals you wnat to display!
You will see per row level as an option when your data is grouped in rows and you have row subtotals turned on, and per column level as an option when your data is grouped by columns and you have column subtotals turned on.
I've run into this same issue before. There's no elegant way to solve it. You can read about how I managed to fix it here
Essentially, you have to abuse the fact that PowerBI doesn't actually sum measures in matrix totals, it recalculates them in a different context. Let me know if you have further questions after reading the linked thread.
Hi Cmcmahan -- thanks for that. Honestly, my table looks a lot less cluttered without subtotals so I may just exclude them entirely. They should really have an easy feature that lets you pick and choose which subtotals you wnat to display!
Hi Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
