Weight of values by two subset level

[Anonymous]

Hi All,

I am having some issues when calculation the total aggregate value by two subsets:

Sales	Subset1	Subset 2	Total Partial aggregation	Expected
4324	Location1	Brand 1	71891	6,01%
67567	Location1	Brand 1	71891	93,99%
9899	Location1	Brand 2	16688	59,32%
6789	Location1	Brand 2	16688	40,68%
5423	Location2	Brand 2	104421	5,19%
98998	Location2	Brand 2	104421	94,81%
8987	Location2	Brand 1	85743	10,48%
76756	Location2	Brand 1	85743	89,52%
4545	Location3	Brand 2	4554	99,80%
9	Location3	Brand 2	4554	0,20%
8796	Location3	Brand 1	17231	51,05%
8435	Location3	Brand 1	17231	48,95%
67567	Location4	Brand 1	157556	42,88%
89989	Location4	Brand 1	157556	57,12%
659678	Location4	Brand 2	694212	95,03%
34534	Location4	Brand 2	694212	4,97%

By using calculate(sum[sales]; ...) I don't find a way to aggregate patialy (Col:Total Partial aggregation)

Has anyone a way to calculate those partial aggregations, that later on meke possible to make aggregation  at two levels.

Thanks in advance!

JC

[BIAB]

Can you provide a sample PBIX file.  I would say that if you create a measure to divide your Total Partical Agregation from your Sales you should get the Expected result.