Total in % for each region Split

Question

Here is my raw data&nbsp;RegionRegion Vol SplitAMERICAS21%APAC79%AMERICAS71.0%APAC9.0%EMEA20.0%EMEA10%APAC55%EMEA16%APAC19%AMERICAS100%AMERICAS100%EMEA100%Americas50%APAC30%EMEA20%Japan79%Canada2%Americas19%APAC100%North America34%APAC28%EMEA38%AMERICAS100%North America100%APAC100%&nbsp;&nbsp;When i pivot it,&nbsp;I get below table which sums up to 1300% which should not be the case.&nbsp;&nbsp;AMERICAS461%APAC420%Canada2%EMEA204%Japan79%North America134%Grand Total1300%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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?&nbsp;Region&nbsp;AMERICAS35.5%APAC32.3%Canada0.2%EMEA15.7%Japan6.1%North America10.3%Grand Total100%

dangar332 · Accepted Answer

hi,&nbsp;shantupm5&nbsp;&nbsp;try belowresult =
var a = sum('tablename'[region vol split])
var b = calculate(sum('tablename'[region vol split]),removefilters('tablename'[region]))
 return
divide(a,b)

Forum Discussion

Total in % for each region Split

2 Replies

Related content

Splitting Column values

Power BI Service Region Move

Fabric region : datacenter region or geographic region

World minus Region split

Cumulative Total

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%

AMERICAS	461%
APAC	420%
Canada	2%
EMEA	204%
Japan	79%
North America	134%
Grand Total	1300%

Region
AMERICAS	35.5%
APAC	32.3%
Canada	0.2%
EMEA	15.7%
Japan	6.1%
North America	10.3%
Grand Total	100%