Forum Discussion
Hierarchal level Calculation - Different DAX for Each Level
Hello, I am new Power BI and not really versed with DAX formula. I am facing a small problem. I have phrased my question in google in many ways but maybe I couldn't express what I want. so let ...
amitchandak
Super User
Super Userifzalahmed , You need isinscope plus x function and values
Assuming these are measures
[Qty TY] , [Cost TY] , [Qty LY] , [Cost LY]
Example of sumx
sumx(values(Table[Category]), ([Qty TY] * [Cost TY]) - ([Qty LY] - [Cost LY] ))
For insinscope , refer https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/