Forum Discussion

dmb6996's avatar
dmb6996
Frequent Visitor
2 years ago

Remove or hide total row sum in matrix table

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 sele...
Need Help
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
dmb6996
Frequent Visitor
2 years ago

Thanks! Will give it a try and let you know

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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