Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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, so when i select a card visual and drag in a measure it will read the supervisors name that relates to the 91% score?





Super User
Super User

@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]))



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




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

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Resident Rockstar
Resident Rockstar

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]))

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

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




Helpful resources

Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors