Only showing grand totals in matrix visual

[DataNinja777]

Hello Power BI Community,

I have a matrix visual which has multiple row fields and I removed the stepped layout as I wanted to have it in the table format rather than the outline format which makes row numbers unnecessarily duplicated when fields have only one item each.  I only would like to have the grand total without subtotal for each fields, but when I removed the subtotal, grand total also disappeared and I couldn't find a way to show grand total.  I'd greatly appreciate it if anyone could let me know how I can add grand total in the matrix visualization with multiple row fields with no stepped layout.  

Thank you!

[Ritaf1983 · Accepted solution]

Hi @DataNinja777 

You need to switch off the row level subtotal of "lowest category".

For example if your matrix is like mine :

you need to switch off the "country" subtotal:

The pbix is attached 

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[DataNinja777]

Thanks @Ritaf1983 and @jayppatel07 

[jayppatel07]

https://community.fabric.microsoft.com/t5/Desktop/how-to-show-grand-total-only-without-subtotal-in-m...

This solution should help you