Forum Discussion

dk_24's avatar
dk_24
Helper I
8 years ago
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 ot...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Infact this one to be precise

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

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Infact this one to be precise

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

 

dk_24's avatar
dk_24
Helper I
8 years ago

Thanks Zubair.

it's working fine.