Forum Discussion
Conditional Matrix Arrangement
Hello, I need to create a matrix so that it recognizes and reflects the division reults on the division row and the manager results in the manager rows. Measures are different (separated) calcula...
Anonymous , I think isinscope can help
if(isincope(Table[Manager]), [Manager % Measure] , []Division % Measure])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Anonymous , I think isinscope can help
if(isincope(Table[Manager]), [Manager % Measure] , []Division % Measure])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Thank you, adapted the example to my data and works awesome, I really appreciate it.