Remove or hide total row sum in matrix table

[dmb6996]

Hi,

I have a matrix table in PowerBI which now shows the sum on a rowlevel (see the percentages). How can I remove or hide these percentages? The summing of percentages makes sense as I have selected this under the field "values", but summing percentages on a row level doesnt make any sense. I already switched the row and column subtotal off. I only want to have the values visible when I open the row (by clicking on the plus):

[PijushRoy]

Hi @dmb6996 

If you select the Matrix visual and go to below option

By default, All are selected.
If I want to trun off, Total for Revenue Type, I will select the Revenue Type and in below sub total option, I will turn off

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

[dmb6996]

Hi, the issue is not with the subtotals (I already switched them off as mentioned).

It is summing the values but it is also summing it on a total rowlevel. I don't want that to happen. I just want to have the values visible when I open the row (by clicking on the plus). If the row is not open I also dont want to see any values.

[PijushRoy]

HI @dmb6996 

For this purpose, You need to use HASONEVALUE DAX
In your screenshot, it is not visible what is the 1st Level, and what is the 2nd Level

I am assuming, 1st Level is County and 2nd Row Level is State

So You need to create a Measure of the Column or exisiting Measure like below

= If(HASONEVALUE(State),[YourExisitngMeasure]," "]

This measure will turn off the total for Country level.

Can you please try and let me know

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

[dmb6996]

Thanks! Will give it a try and let you know

[PijushRoy]

Hi @dmb6996 

Can you please try and let me know if you still facing the same issue? 
If solve, please MARK THE ANSWER AS SOLUTION

Thanks
Pijush

[Ritaf1983]

Hi @dmb6996 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523