Percent of total Error - Interactive

[Anonymous]

Hi Experts, 

I am after retaining the interactivity between visuals and show % of total split by advance shipment. 

When I use formula for base in line 3, the totals come out correct however i loose interactivity. But, when I use formula for base in line 4, I retain the interactivity between visuals. however totals for few months is not coming out right. Whats the best to address this. 
#percentoftotal #dax #calculate

[PurpleGate · Accepted solution]

I used this on your sample data. 

Measure 2 = 
var curr = SELECTEDVALUE('Table (2)'[Vol])
var base = CALCULATE(sum('Table (2)'[Vol]),REMOVEFILTERS('Table (2)'[ADVANCE SHIPMENT]))
return COMBINEVALUES(",", curr, base)

It shows the split ok, just doesnt show the full 100% split for the total columns. 

[Anonymous]

This is the sample data - 

Released_YYYMM	Vol	ADVANCE SHIPMENT	RECLASS DEMAND TYPE
22-Mar	345	No	Non-Warranty
22-Mar	757	No	Warranty
22-Mar	158	Yes	Non-Warranty
22-Mar	687	Yes	Warranty
22-Apr	293	No	Non-Warranty
22-Apr	597	No	Warranty
22-Apr	163	Yes	Non-Warranty
22-Apr	795	Yes	Warranty
22-May	254	No	Non-Warranty
22-May	765	No	Warranty
22-May	136	Yes	Non-Warranty
22-May	589	Yes	Warranty
22-Jun	230	No	Non-Warranty
22-Jun	559	No	Warranty
22-Jun	167	Yes	Non-Warranty
22-Jun	545	Yes	Warranty
22-Jul	217	No	Non-Warranty
22-Jul	555	No	Warranty
22-Jul	159	Yes	Non-Warranty
22-Jul	665	Yes	Warranty
22-Aug	131	No	Non-Warranty
22-Aug	333	No	Warranty
22-Aug	55	Yes	Non-Warranty
22-Aug	177	Yes	Warranty