Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use this
Max(Aggr(Sum([Sales]), [Country]))