Get Maximum Value Text

[Syndicate_Admin]

Hello Comrades

I need to get the Most Repeated Value Text for a certain value in a column, I have these people who appear repeatedly and within each value I want to know which one appears the most. For example, in the extra column, for everything that is equal to "KEYFT&T" I will see "Sandoval" Since it is the one with the highest count

Best regards

[arava]

If you'd like to make a calculated column, you can use the below formula and set the filter value to 1. 

myColumn = RANKX(myTable, CALCULATE(COUNTROWS(myTable), FILTER(myTable, EARLIER(myTable[myColumn]) = myTable[myColumn])))

[Greg_Deckler]

@Syndicate_Admin Seems like a pretty straight-forward lookup min/max. Lookup Min/Max - Microsoft Fabric Community

[Syndicate_Admin]

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

[Anonymous · Accepted solution]

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.