Sum, slicer, filter and average and weighted index

[pitucc]

Hello All,

I am trying to compute weigthed values that change dynamicaly with the slicer i selectin my report

One table, 4 column : Name; region, price ; Volume 

I want to compute the weighted price  by volume  

for "a" :  5* 100  / ( sum all volume = 755) 

"b": 1* 105 / 755 

etc... 

I managed to have something that works but if i choose to slice by region for instance, my weighted price  by volume  remain the same same if I want to select only a b c with a slicer. I tried with calculate and  allselected, all, allexecpt, but i getting crazy... 

Thanks for your help 

[pitucc · Accepted solution]

finally found a solution : 

SUMX(ALLSELECTED(Table1);Table1[Volume])