Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
finally found a solution :
SUMX(ALLSELECTED(Table1);Table1[Volume])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |