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 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):

 

 

Need Help

6 Replies

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

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

      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'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