Retrieve Text based on max value

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

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