Matrix calculated subtotals

[Anonymous]

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

[Anonymous]

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.

[amitchandak]

@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/

[Anonymous]

This is the database :

And i need to create a matrix-like the first one