cancel
Showing results for
Did you mean:
Helper III

## Get the MIN and MAX of occurrences in a column

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.

1 ACCEPTED SOLUTION
Super User IV

@Sach 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])
``````

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

2 REPLIES 2
Super User IV

@Sach 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])
``````

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Helper III

That worked perfect, thanks!

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.