Forum Discussion
SUMX Hierarchy for ABC
Thanks for your Reply. sadly i wasn´t able to get the result i expected.
i modified my pbix file so that i can share it.
Example File
I hope the Link does work.
I have the a Hierarchy with "Warengruppe" --> "Artikelgruppe" --> "Artikel", where Article ist the most specific level.
Like you can see in the Screenshot from my post, th ABC analysis is working on the Artikel level. but if i add the "Warengruppe" for the information aspect it creates an Rank 1,2,3 and so on for every category and the cumulativ Net Value is also for the Categorys from "Warengruppe".
One question would be how i can prevent that and the more important point is how can i get my other visual on the side right. my Measure get the amount of A/B/C articles for each Month right but if i want to show how many of the A-Article belong to each Category from "Warengruppe" it doesnt sum up to the total of A-Articles and instead shows way to high numbers.
In my Example FIle the expected Result for 2023.03 should be
20203.03 50
A 29
Brötchen 13
Brote 5
Gebäck 7
Kuchen 4
B 21