A Card Visual That Relates to Another Measure

[tomsmith213]

Hi, I have finally managed to create a measure that reads out the higest value (I'm new lol) but now I need another card visual that reads out the supervisors name.

Any ideas how to go about this, so when i select a card visual and drag in a measure it will read the supervisors name that relates to the 91% score?

[amitchandak]

@tomsmith213 ,

Just Noticed @djurecicK2 , Already replied. Please check that solution first , Please check this only if that did not work.

Create a TOPN Measure

Top Utilization % =

CALCULATE( [Utilization %] ,TOPN(1,allselected('Table'[Supervisor]), [Utilization % ,DESC),values('Table'[Supervisor]))

Supervisor

CALCULATE( max('Table'[Supervisor]) ,TOPN(`,allselected('Table'[Supervisor]), [Utilization % ,DESC),values('Table'[Supervisor]))

or

maxx(TOPN(`,allselected('Table'[Supervisor]), [Utilization % ,DESC), [Supervisor])

[djurecicK2]

Hi @tomsmith213 ,

 You can try something like this:

Please adjust for your table and column names

Max Utilitisation Supervisor= CALCULATE(MAX(TableName[Supervisor Name]), FILTER(ALL(TableName), Tablename[% Shift]= [max utilisation]))

[tomsmith213]

Hi, thanks for the reply, but where have I gone wrong?