Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Summarize average of highest attemps
10-07-2022
12:14 AM
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.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2022
06:28 PM

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2022
09:10 AM

I tried this but it gives an error
Avg Score = AVERAGEX(SUMMARIZECOLUMNS(Table[Student],"Score",MAX(Table[Score])),[Score])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2022
01:19 AM

Hi, try this one
Average = AVERAGEX(SUMMARIZE([Student], MAX([Score]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2022
06:28 PM

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2022
08:37 AM

I think there are a syntax errors

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
01-18-2025 10:21 AM | |||
09-06-2021 07:09 AM | |||
Anonymous
| 05-15-2024 06:43 PM | ||
02-11-2025 08:18 AM | |||
01-28-2025 03:52 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
47 |