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 ...
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/
This is the database :
And i need to create a matrix-like the first one