Hello everybody,
I have a dataset containing values of performance on lifting exercises.
On my dashboard, I have two slicers to select players or to select the exercise. And I created some measures to have the best performance in the exercice for the player and the exercise selected.
Best Perf (All Players) = CALCULATE(MAX(df[Max Weight]),ALL(df[Player]),VALUES(df[Exercises]))
Best Perf (Selected Player) = CALCULATE(MAX(df[Max Weight]),df[Player] = SELECTEDVALUE(df[Player]),VALUES(df[Exercises]))
My goal is to create a column chart with all the values of the selected player and to display on the right of the column chart my two measures : the value of the best player perf and the value of the best team perf. It would look like that :
However, I do not know how to join my values and my measures.
Thanks in advance for your time and your help
