Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
PBI file attached.
Hope this helps.
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.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |