Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Infact this one to be precise
=sum(Table1[Sales])-Calculate(AVERAGE(Table1[Sales]),EXCEPT(All(Table1),Allselected(Table1)))
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |