Dax help to bring back the max percentage back in a matrix

[quintans1]

I am trying to figure out how to display the maximum hit rate for a boxer per location in a matrix. I wrote the dax calcMaxHitRate, but I know that is pulling back the highest rate for a single row of data, while I am looking for the aggregate of the location.

For example, Boxer #2 has a hit rate of 95.4% overall, but their best hit rate is Fresno at 96.7%.

My challenge is I figured out how to write the display to show the “Top Gym” (text), but how do I write the dax to show me the 96.7% (because Fresno is the best) for Boxer #2, 96.6% for Boxer #1 (because Toledo is the best) and so on?

Link to PBIX here

I know Fresno is the top gym for Boxer 2, but want to show in this matrix the actual percentage.

[Jihwan_Kim · Accepted solution]

Hi,

Please try something like below whether it suits your requirement.

calcMaxHitrate =
MAXX ( SUMMARIZE ( Sheet1, Sheet1[Location] ), [HitRate] )

[quintans1]

This worked, thank you very much.