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)
AaronGlenn10 , Try TOPN
Top 1= calculate(max(Table[restutant]),TOPN(1,allselected(table[restutant]),[Total Measure],DESC), values(table[restutant]))