cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## 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
Resolver I

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
Resolver I

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]))

Resolver I

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.
Resolver I

I think there are a syntax errors

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors