Is it possible to Unhide only Total in Matrix table

[harirao]

Hi Team,

I have created a Matrix, i want to show subtotal, Grant Total is not required, how to deselect this grand total

Regards,

[Anonymous]

Hi @harirao 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @harirao 

You can achieve your goal by turn on Per row level function in Subtotal in Visualization Format.

My Sample Matrix visual:

Find Subtotal in Format and expand it.

Turn on Per row level and turn off Level 1, keep Level 2.

Result is as below.

Best Regards,

Rico Zhou

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

[amitchandak]

@harirao , Matrix grand total does have the option to hide. You can use isinscope or isfiltered to make it blank

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

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/