Show value of Max dimension

[jgreen95]

I have used the solution  here  to use the First Sorted Value function to show the dimension with the highest value.

How would I show the value for said dimension?

I know it could be done with an IF statement but i have over 200 dimensions so this would be ridiculous.

[sunny_talwar · Accepted solution]

Use this

Max(Aggr(Sum([Sales]), [Country]))