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.
Here is my raw data
Region | Region Vol Split |
AMERICAS | 21% |
APAC | 79% |
AMERICAS | 71.0% |
APAC | 9.0% |
EMEA | 20.0% |
EMEA | 10% |
APAC | 55% |
EMEA | 16% |
APAC | 19% |
AMERICAS | 100% |
AMERICAS | 100% |
EMEA | 100% |
Americas | 50% |
APAC | 30% |
EMEA | 20% |
Japan | 79% |
Canada | 2% |
Americas | 19% |
APAC | 100% |
North America | 34% |
APAC | 28% |
EMEA | 38% |
AMERICAS | 100% |
North America | 100% |
APAC | 100% |
When i pivot it, I get below table which sums up to 1300% which should not be the case.
AMERICAS | 461% |
APAC | 420% |
Canada | 2% |
EMEA | 204% |
Japan | 79% |
North America | 134% |
Grand Total | 1300% |
I divided each region by grand total (ex: Americas (461%/ 1300%) which results to 35% as illustrated in the below table. How can we solution this in power bi?
Region | |
AMERICAS | 35.5% |
APAC | 32.3% |
Canada | 0.2% |
EMEA | 15.7% |
Japan | 6.1% |
North America | 10.3% |
Grand Total | 100% |
Solved! Go to Solution.
hi, @shantupm5
try below
result =
var a = sum('tablename'[region vol split])
var b = calculate(sum('tablename'[region vol split]),removefilters('tablename'[region]))
return
divide(a,b)
hi, @shantupm5
try below
result =
var a = sum('tablename'[region vol split])
var b = calculate(sum('tablename'[region vol split]),removefilters('tablename'[region]))
return
divide(a,b)
You are amazning! Thank you so much 🙂
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |