Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
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])
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]))
Hi, thanks for the reply, but where have I gone wrong?
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |