Return Max Result by Sales

[AaronGlenn10]

Power BI Rock Stars:

I have a summary page for restaurant sales where users can select a CITY to review the total of all restaurants within that CITY. Trying to find a measure that will return the name of the restaurant within the SELECTED CITY that reported the highest sales for the current month.  Thank you! ~A

[Ashish_Mathur · Accepted solution]

Hi,

This measure should work

=FIRSTNONBLANK(TOPN(1,VALUES(Restaurants[Name]),[Total Sales]),1)

[AaronGlenn10]

Ashish:

That worked - thank you!  How would I also return the sales amount ($) associated with that restaurant?

~A

[Ashish_Mathur]

You are welcome.  Please mark that reply as Answer.  Try this measure

=MAXX (Restaurants,[Total Sales])

[amitchandak]

@AaronGlenn10 , Try TOPN

Top 1= calculate(max(Table[restutant]),TOPN(1,allselected(table[restutant]),[Total Measure],DESC), values(table[restutant]))

TOPN https://youtu.be/QIVEFp-QiOk