Remove a totals rom in a matrix

[Joe_Grosskopf]

I have a matrix with groups and totals. T do not need grouping on the final detail row as it only shows what is in that row already. How do I remove that total? I attached a Screen shot highlighting (in yellow) the row to remove.  Also, I am getting a total on the percent column, casn I tell the matric not to summarize a column (highlited in green)?

[v-yueyunzh-msft · Accepted solution]

Hi , @Joe_Grosskopf 

According to my research and testing, you can set the option to enable or disable Subtotal through each level in the column or row of the matrix with format settings, and you can navigate according to the corresponding settings of my screenshot and check whether the test can achieve your functional requirements through this setting:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Joe_Grosskopf , you have an option per level in row/column sub totals to remove specific subtotals

or you can use isinscope to change total with something else

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

IsInScope - Switch measure at different levels: https://youtu.be/kh0gezKICEM