Forum Discussion

lsolomon1's avatar
lsolomon1
Frequent Visitor
7 years ago

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?