Measure to show text related to another measure

[Anonymous]

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:

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.

[lc_finance]

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