Forum Discussion
Help - New to PowerBI
Hello,
I have a Product Hirerachy (Department, Category, SubCategory, Style, Color) and a Local Measure I created called [Constrained Order Revenue $'s].
I am using a Matrix Table and my ROWS are the Product Hirerachy and the Value is my Local Measure [Constained Order Revenue $'s].
What I am trying to do is Calculate the % of each level of the hirerachy to the next level (rolled up).
Example: Let's say Department has 2 options (Men and Women) and together they have a total of 1,250 of [Constained Order Revenue $'s]. (Men's = 1,000 and Women's = 250). I want to get the percent of the total for each (Men's = 1,000 / 1,250 = 80%) (Women's = 250 /1,250 = 20%)
Then I would do the same logic for the rest of the hirerachy.
% to TTL Department = CALCULATE(Constained Order Revenue $'s]) / calculate(Constained Order Revenue $'s], ALLSELECTED('Products'[Department]))
I can't get it to work. Any ideas?
1 Reply
- v-piga-msftResident Rockstar
Hi lsolomon1 ,
More details could help us understand your scenario better.
Please share your data sample as table format and your desired output so that we could help further on it.
Reference: How to Get Your Question Answered Quickly.
Best Regards,
Cherry