cancel
Showing results for
Did you mean:  Helper II

## Summarize average of highest attemps

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

1 ACCEPTED SOLUTION  Helper II

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.
4 REPLIES 4  Helper II

I tried this but it gives an error

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

Hi, try this one

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

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.  Helper II

I think there are a syntax errors  