Forum Discussion

tomsmith213's avatar
tomsmith213
Frequent Visitor
3 years ago

A Card Visual That Relates to Another Measure

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...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

tomsmith213 ,

Just Noticed djurecic , 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])