Forum Discussion
Solved
Dynamic Slicer Selection Calculation
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.
Infact this one to be precise
=sum(Table1[Sales])-Calculate(AVERAGE(Table1[Sales]),EXCEPT(All(Table1),Allselected(Table1)))
3 Replies
Hello DK
Try this measure
=Calculate(AVERAGE(Table1[Sales]),EXCEPT(All(Table1),Allselected(Table1)))Infact this one to be precise
=sum(Table1[Sales])-Calculate(AVERAGE(Table1[Sales]),EXCEPT(All(Table1),Allselected(Table1)))Thanks Zubair.
it's working fine.
