Measure for sales to include hierarchy

[mohammedmahadik]

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

[Ashish_Mathur]

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.

[mohammedmahadik]

Hi Ashish,

Please find the requirement in the attached excel

https://we.tl/t-hQmSnN1gda

[Ashish_Mathur · Accepted solution]

PBI file attached.

Hope this helps.