Forum Discussion
Advocate IMatrix Visual – Avoid Totals on Branches Without Further Levels
Hi everyone,
I’m working with a matrix visual based on an unbalanced hierarchy (some branches go deeper than others).
Is there a way to hide the repeated “Total” rows for branches that don’t continue to the next level?
Right now, even when a branch ends at, say, Level 2, the matrix keeps showing blank or repeated “Total” rows for Level 3, 4, and 5 — even though there's nothing more to drill into.
Thanks in advance!
Hi Nazdac2024 ,
This depends on how you have your hierarchy build and on the measures that you are using.
Check this video that allows you to do that with 2 additonal measures on your model and an adjustment on your calculaition.
https://www.youtube.com/watch?v=RTDKQQI9vUA
I have made a small example in the PBIX attached
5 Replies
- MFelix
Super User
Hi Nazdac2024 ,
This depends on how you have your hierarchy build and on the measures that you are using.
Check this video that allows you to do that with 2 additonal measures on your model and an adjustment on your calculaition.
https://www.youtube.com/watch?v=RTDKQQI9vUA
I have made a small example in the PBIX attached
v-tejramaCommunity Support
Hi Nazdac2024 ,
Thank you MasonMA and MFelix for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you for your understanding!- v-tejrama
Hi Nazdac2024 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Thank you.
- MasonMA
Hi, You may try:
1. Under Row subtotals have both 'Row subtotal' and 'Per row level' turned On,
then Under 'Apply settings to', for 'Show sutotal' under 'Rows' only have 'Show Subtotal' set to ON for those row levels you wanted to show on Matrix.
Hope this helps:)
