Power BI or Paginated - Custom Subtotals?

[thx1137]

All,

Trying to construct a matrix visual that shows values for individual members of a field, with subtotals below the individuals showing groupings of those individual members, plus a total of all members.  Here is an example:

I've done this with other tools (I believe it is called "stacking") and can achieve it in Power BI Desktop by creating individual measures using CALCULATE with filter for the individual members of a group but wondering if there is a better way.  Is the situation any better with Power BI Paginated?

[thx1137]

Found this was easier to do (without resorting to inserting blanks and such) in Power BI Paginated....which has spawned other challenges...

[amitchandak]

@thx1137 , I assume you need additional rows before the total. For that, You need to have values in your dimension of use additional dimension

refer to how this done in P&L

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e...

Also, refer

How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA