Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AaronGlenn10
Helper III
Helper III

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 the name of the restaurant within the SELECTED CITY that reported the highest sales for the current month.  Thank you! ~A

 

AaronGlenn10_0-1645228125026.png

 

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

This measure should work

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

This measure should work

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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])

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.