Forum Discussion
Helper IIIMin/max/AVG by filters data
Hi Jeremy19 ,
Is this what you want? Or you want a "Player" slicer?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Jeremy19 ,
" In addition, only on condition C1. For exemple if I select player A, min =1086, avg=1141 and max=1237."
Regarding the example you gave, I can’t understand how the maximum, minimum and average values are calculated. Could you explain it with mathematical formulas?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jeremy19Ok,
Step 1 : select the maximum values per player of the same position and for condition C1. If I select a player who has the G1 position : 1100 for A, 1237 for B and 1086 for C.
Step 2 : Three measures to obtain the min / avg / max among the values of step 1
In my example if I select player D as he is alone in his group the final result will be 1363 for min, avg and the max.
- v-lionel-msft
Hi Jeremy19 ,
Is this what you want? Or you want a "Player" slicer?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.