Retrieve Text based on max value

[yewling1201]

Hi,

How do I retrieve the Item name based on the highest # of Customers? Eg: highest # of customers is 78, how do i rerieve Rice?

Thank you!

[Samarth_18 · Accepted solution]

Hi @yewling1201 ,

Please try below measure :-

Measure = 
var _max_cust = CALCULATE(MAX('Table'[# of customers]),ALL('Table'[# of customers]))
return CALCULATE(MAX('Table'[Item]),FILTER('Table','Table'[# of customers] = _max_cust))

BR,

Samarth

[yewling1201 · Accepted solution]

I really apprecipate your swift response, Samarth. Thank you so much! 

[Samarth_18 · Accepted solution]

Hi @yewling1201 ,

Please try below measure :-

Measure = 
var _max_cust = CALCULATE(MAX('Table'[# of customers]),ALL('Table'[# of customers]))
return CALCULATE(MAX('Table'[Item]),FILTER('Table','Table'[# of customers] = _max_cust))

BR,

Samarth