Get the MIN and MAX of occurrences in a column

[Anonymous]

I have a set of game data, which is points scored by players in games they've played. Looks like this:

Player,Points
A,12
A,33
A,44
A,6
A,3
A,86
A,43
A,77
A,4
A,94
B,44
B,66
B,8
C,34
C,64
C,55
C,34
C,25
C,3

I have a measure I calculate to get the number of games played by each player, and it's pretty simple.

Games = COUNTROWS(GameData)

Now I can use this to display the number of games played by each player and total points they've scored, like so:

Now, to be used elsewhere, I also want to get the max and min games played by a player in the entire data set. If we consider the above dataset, I want to get the number 10 (which is the most number of games played by any player) and 3 (which is the min), as measures.

What's the best way to do this?

EDIT:

I want to add that I'm looking for a way to do this without using calculated columns, the reason being that I want to get the same MAX and MIN count for other fields in my data as well, and some of them are measures calculated based on other conditions.

[Greg_Deckler · Accepted solution]

@Anonymous You should be able to do something like this:

Max Games Measure = MAXX(SUMMARIZE('Table',[Player],"__Games",[Games]),[__Games])

Min Games Measure = MINX(SUMMARIZE('Table',[Player],"__Games",[Games]),[__Games])

[Anonymous]

That worked perfect, thanks!