Forum Discussion
Get Maximum Value Text
Thank you Greg_Deckler and arava
Hi, Syndicate_Admin
Based on your description, I've used the following sample data:
I created a measure using the following DAX expression:
Max_Conteo_name = VAR _KEYFT = SELECTEDVALUE('Table'[KEYF&T&T]) VAR _Conteo = MAXX(FILTER(ALL('Table'),'Table'[KEYF&T&T]=_KEYFT),'Table'[Conteo]) RETURN MAXX(FILTER('Table','Table'[Conteo]=_Conteo&&'Table'[KEYF&T&T]=_KEYFT),'Table'[SUP])Put the KEYF&T&T and this metric into the table visual, and you can see that for each different KEYF&T the corresponding SUP with the largest Conteo is returned.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not as such, because what I want to return to me is a text, not so much what is the maximum but the name of the one that has the maximum value
Thank you Greg_Deckler and arava
Hi, Syndicate_Admin
Based on your description, I've used the following sample data:
I created a measure using the following DAX expression:
Max_Conteo_name =
VAR _KEYFT = SELECTEDVALUE('Table'[KEYF&T&T])
VAR _Conteo = MAXX(FILTER(ALL('Table'),'Table'[KEYF&T&T]=_KEYFT),'Table'[Conteo])
RETURN
MAXX(FILTER('Table','Table'[Conteo]=_Conteo&&'Table'[KEYF&T&T]=_KEYFT),'Table'[SUP])Put the KEYF&T&T and this metric into the table visual, and you can see that for each different KEYF&T the corresponding SUP with the largest Conteo is returned.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.