Forum Discussion
Solved
Return 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 th...
Hi,
This measure should work
=FIRSTNONBLANK(TOPN(1,VALUES(Restaurants[Name]),[Total Sales]),1)
Ashish:
That worked - thank you! How would I also return the sales amount ($) associated with that restaurant?
~A
You are welcome. Please mark that reply as Answer. Try this measure
=MAXX (Restaurants,[Total Sales])