I am attempting (and failing) to calculate the average BEST score for student tests by subject (Math, English, and Writing) and ignore their non-best scores.
Here's my goal:
Here is the dummy data:
Thanks to anyone who can help!
Go to Solution.
If you have the Notes column on the real data then VahidDM's solution is likely to be the fastest.
When I read the question I assumed the Notes column isn't in the real data. If that's the case a measure like this will get your answer.
Average Best Score =
SUMMARIZE('Table', 'Table'[ID], 'Table'[Test]),
*btw your note for ID 1's best Math score doesn't look right. Shouldn't it be on the line above - score = 75?
View solution in original post
Thank you so much! Yes you're correct, I had noted #1's highest math score incorrectly. My apologies, I was about to race out of the office before posting this and my brain was somewhere else!
You are the best! Many many thanks.
Try this measure:
verage Best =
AVERAGE ( 'Table'[Score] ),
FILTER ( 'Table', 'Table'[Notes] <> "" )
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos🙏!!
Hello, Paul is correct above - the Notes column is not actually included in my data. But thank you!
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!