Summarize average of highest attemps

[gancw1]

I have a student score table

Session	Student	Score
Morning	A	6
Morning	A	10
Morning	B	6
Afternoon	C	8
Afternoon	C	4
Afternoon	C	9
Afternoon	D	4
Afternoon	D	6

and I can report the highest score for each student

Session	Student	Highest Score
Morning	A	10
Morning	B	6
Afternoon	C	9
Afternoon	D	6

How do I calculate the average of the highest score for each session ?

Session	Average
Morning	8
Afternoon	7.5

[gancw1]

I tried this but it gives an error

Avg Score = AVERAGEX(SUMMARIZECOLUMNS(Table[Student],"Score",MAX(Table[Score])),[Score])

[HoangHugo]

Hi, try this one

Average = AVERAGEX(SUMMARIZE([Student], MAX([Score]))

[gancw1 · Accepted solution]

I managed to get the measure to work.

Avg Score = AVERAGEX(SUMMARIZE(Table, [Session],[Name],"Score",MAX(Table[Score])),[Score])

The problem with the previous measure has to do with using SUMMARIZECOLUMN instead of SUMMARIZE.  

[gancw1]

I think there are a syntax errors