Dynamic Measures - Visualisation based on highest value

Hey Daniel_B ,

There are probably other ways to do this, however this was my solution:

1. Create a measure to calculate the average rating per site
2. Create another measure to calculate the maximum of the average ratings
3. Create a calculated table, filtered to show only the row where Average Rating = Max Rating
4. Use the calculated table to populate the guage & label (I use a card showing only the Site Name)

Tables

xAvgRating = AVERAGEX(Ratings, Ratings[Rating])

xMaxRating = 
CALCULATE(MAXX(Ratings, Ratings[xAvgRating]), ALL(Ratings))

tMaxVal = 
FILTER(Ratings, [xMaxRating] = [xAvgRating])