Forum Discussion

mohammedmahadik's avatar
mohammedmahadik
Frequent Visitor
2 years ago
Solved

Measure for sales to include hierarchy

Hi I have a table with sales value and HQ.

Now each city can have multiple HQ. For example, Chicago 1, Chicago 2, Chicago Pool

 

I want a measure which calcuates sales such as-

Chicago 1 = Chicago 1 + 0.6*Chicago Pool

Chicago 2 = Chicago 2 + 0.4*Chicago Pool

 

Now there will be different city HQs within a state where similar logic would apply. I want that the above calculations apply to the whole state if I were to select the state instead of individual HQs

3 Replies