matrix - power bi - porcentagem %

[Portrek]

Hello Forum members, I'm updating the old Excel reports for Power bi and I came across the following situation, a table where the subtotals are shown as a percentage relative to the values above, see the small table below as a small example of what I would like to do

Produto       JAN       FEV      MAR

Teto 1           10        20           18

Teto 2            5         15             2

%             50 %     75%      11% 

Teto 3          12          18          23

Teto 4            5           15           2

%             42%      83%       9%

Are the lines of % that I would like to create as subtotais, is there any way to mount this in power bi ??

Any suggestions for the preparation of this report that showed at the informatios that way are welcome.

Thank you all.

[v-chuncz-msft · Accepted solution]

@Portrek

You can try toISINSCOPEto change the total.

• https://community.powerbi.com/t5/Desktop/Dynamic-Difference-Measure-Using-Slicer/m-p/590745#M280280
• https://community.powerbi.com/t5/Desktop/Pivot-Table-Subtotal-Summing-Multiple-Columns/m-p/769529#M3...

[parry2k]

@Portrek what is the logic to group products together, you should add a column in your table called Group and assign value to group the product you want to group together and add that group in your matrix volume and it will group products together.