Dynamic Slicer Selection Calculation

[dk_24]

Hi All,

SAMPLE Data:

User	Sales
U1	120
U2	100
U3	95
U4	110

I Have a slicer with User , Suppose if i select U2 , U2 sales is 100, now i want to compare with the other users 

Ex = Slicer selection U2

100 - (120+95+110)/3 

the difference with the remaing users are -8  .

suppose if i select U4 in Slicer

the output should be 110 - (120+100+95) /3 = -5 

Thanks,

DK.

[Zubair_Muhammad]

Hello DK

Try this measure

=Calculate(AVERAGE(Table1[Sales]),EXCEPT(All(Table1),Allselected(Table1)))

[Zubair_Muhammad · Accepted solution]

Infact this one to be precise

=sum(Table1[Sales])-Calculate(AVERAGE(Table1[Sales]),EXCEPT(All(Table1),Allselected(Table1)))

[dk_24]

Thanks Zubair.

it's working fine.