Forum Discussion
Matrix calculated subtotals
Hi, I need to make a matrix like this one below. In the database I have only the value (like Rev1,Cost2,Dep1,Tax...), while I need to calculate the other (Revenues, Cost, Ebit Earning ..) How can I ...
Hi Anonymous
You can turn on row and column subtotals in Visual Format settings .
You can also sum the value by per column level and per row level in Subtotals, if your data has a hierarchical structure .
If you want to create measure to calculate subtotals ,you can refer to the sample that I searched in forums .
https://community.powerbi.com/t5/Desktop/Calculate-MAX-for-subtotals/m-p/1754821
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.