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

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors