Forum Discussion
Remove or hide total row sum in matrix table
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.
Community ChampionHI 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