Reply
gancw1
Resolver II
Resolver II
Partially syndicated - Outbound

Summarize average of highest attemps

I have a student score table

SessionStudentScore
MorningA6
MorningA10
MorningB6
AfternoonC8
AfternoonC4
AfternoonC9
AfternoonD4
AfternoonD6

 

and I can report the highest score for each student

 

SessionStudentHighest Score
MorningA10
MorningB6
AfternoonC9
AfternoonD6

 

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

 

SessionAverage
Morning8
Afternoon7.5

 

 

1 ACCEPTED SOLUTION

Syndicated - Outbound

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.  

View solution in original post

4 REPLIES 4
gancw1
Resolver II
Resolver II

Syndicated - Outbound

I tried this but it gives an error

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

Syndicated - Outbound

Hi, try this one

 

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

Syndicated - Outbound

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.  

Syndicated - Outbound

I think there are a syntax errors

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)