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 accomplish with task?
Thanks
3 Replies
Anonymous , isinscope can allow you shift calculation.
But are these measures or row values?
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
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.
