Return Max value of column based on multiple criteria from multiple columns

[SealDog]

Hi All,

I'm trying to determine the max value for a column based on multiple criteria from a number of columns.

For example i want to determine the MAX students value from the students column for all rows that contain the same values in columns school, semster and class.

School	Semester	Class	Students
School 1	1	English	10
School 2	2	Math	5
School 1	1	English	10
School 1	1	English	5
School 1	1	Math	10
School 2	2	Science	5
School 2	2	Science	10
School 2	1	Science	5

Cheers 

[Zubair_Muhammad · Accepted solution]

Hi @SealDog

I think a simple measure

Max_Students = Max(Table1[Students])

should do the job.