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 

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

      • dmb6996's avatar
        dmb6996
        Frequent Visitor
        2 years ago

        Thanks! Will give it a try and let you know