Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |