Forum Discussion
AaronGlenn10
Helper III
Helper IIIReturn Max Result by Sales
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
Hi,
This measure should work
=FIRSTNONBLANK(TOPN(1,VALUES(Restaurants[Name]),[Total Sales]),1)
4 Replies
- amitchandak
Super User
AaronGlenn10 , Try TOPN
Top 1= calculate(max(Table[restutant]),TOPN(1,allselected(table[restutant]),[Total Measure],DESC), values(table[restutant]))
- Ashish_Mathur
Hi,
This measure should work
=FIRSTNONBLANK(TOPN(1,VALUES(Restaurants[Name]),[Total Sales]),1)
AaronGlenn10Ashish:
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])
