Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
gancw1
Helper III
Helper III

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

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

I tried this but it gives an error

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

Hi, try this one

 

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

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.  

I think there are a syntax errors

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.