MAX Function

[shantupm5]

I have a measure which i have created and result of the measure is something like this. I need to find out Max value out of this output.

	Accuracy
Customer 1	99.97%
Customer 2	99.82%
Customer 3	99.82%
Customer 4	99.96%
Customer 5	99.97%
Customer 6	99.66%

However i get below error message

[jdbuchanan71 · Accepted solution]

@shantupm5 

You need to look at the MAXX function.  It works like this.

If you have a measure that calculates sales 

Sales = SUM ( Sales_Table[Sales Amount] )

And you want the MAX Sales amount across all customers it would be

Max Sales = MAXX ( Values ( Customer[Customer Number] ), [Sales] )