Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 |
Solved! Go to Solution.
I managed to get the measure to work.
Avg Score = AVERAGEX(SUMMARIZE(Table, [Session],[Name],"Score",MAX(Table[Score])),[Score])
I tried this but it gives an error
Avg Score = AVERAGEX(SUMMARIZECOLUMNS(Table[Student],"Score",MAX(Table[Score])),[Score])
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])
I think there are a syntax errors
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
86 | |
85 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |