Subtotal in a Matrix

[rpinxt]

Keep running into this and am hoping that by now this got fixed somehow.

But I cannot find the correct setting.

So this Matrix:

Its rather simple...get rid of the subtotals but keep the grandtotal.

Is this still not possible in Power BI?

ps: no I do not want to use a list. I would need the matrix.

[Idrissshatila · Accepted solution]

Hello @rpinxt ,

Yes it is possible in the matrix, you need to click on row subtotals then turn on the per row level setting, then select the row name that you want to modify and turn off the show subtotal.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[rpinxt · Accepted solution]

Ok....found it. Why they make it so difficult I have no idea.

But you where right @Idrissshatila 

How ever when you have moren than 1 level (in my case 2) you apprently switch the lowest (PH2 in my case) off and let the other on.

Now I have no subtotals but still a grand total 😄

[Idrissshatila]

@rpinxt , 

yes, it also works with more than 2 levels, i've recently worked it with 3 or 4 levels and yes I know it looks so comlex to fiigure out.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[rpinxt]

thanks @Idrissshatila but I must be doing somehting wrong then.
I have (for now) 2 levels:

So if I select one and do switch it off :

And then I switch the other off to it still also takes out the Grand Total!

[Idrissshatila · Accepted solution]

Hello @rpinxt ,

Yes it is possible in the matrix, you need to click on row subtotals then turn on the per row level setting, then select the row name that you want to modify and turn off the show subtotal.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin