Forum Discussion

maxduff59's avatar
maxduff59
Helper II
3 years ago

Display measure and values on column chart

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

No RepliesBe the first to reply