Forum Discussion
mohammedmahadik
2 years agoFrequent Visitor
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
PBI file attached.
Hope this helps.
3 Replies
- Ashish_Mathur
Super User
Hi,
Share some data to work with and show the expected result in a simple Table format. Share data in a format that can be pasted in an MS Excel file.
- mohammedmahadikFrequent Visitor
- Ashish_Mathur
Super User