cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## 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 III

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 III

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 III

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 III

I think there are a syntax errors