Forum Discussion
Solved
MAX Function
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%...
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] )
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] )