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

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines
Memorable Member
Memorable Member

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


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.