Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |