Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Measure to show text related to another measure

Hi Team,

 

I'm trying to set up a card to show the number (this is set up as a string in the model) of the account related to the below measure.

 

YOY Account with Highest Balance = MAXX(SUMMARIZE('GCOA_SAP_BL','GCOA_SAP_BL'[Account]),[YoY])
 
This is the matrix related:
 
Max value.PNG

When I have in the category slicer "DNP Cost" is selected and there is another one   for the period (in this case the month of Sep).

The measure is a card and will show 8.9m in this case which is correct and relates to the highest value on this category.

I would like to have another card that shows "480001" which is the account driving this value.

 

Is this possible?

 

Thanks in advance.

 

1 REPLY 1
lc_finance
Solution Sage
Solution Sage

Hi @Anonymous ,

 

 

Have you tried the LOOKUPVALUE formula?

Once you know the highest number is 8.9m, you can use LOOKUPVALUE to find the account associated to that number.

 

Does this help you?

 

LC

Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.