Forum Discussion

Helper III

5 years ago

Solved

Min/max/AVG by filters data

Hello, I have two tables "DB" Name Var1 Date Condition A 1000 43831 C1 A 1100 43832 C1 A 1362 43831 C2 A 740 43832 C2 B 1237 43831 C1 B 1354 43832 C2 ...

Need Help

v-lionel-msft
5 years ago
Hi Jeremy19 ,

Is this what you want? Or you want a "Player" slicer?

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.

by filters data.pbix31 KB

Jeremy19

Helper III

5 years ago

Ok,

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