Aggregation of counts above the average value

[yyjp]

From the original data as below,
In conjunction with the slicer,
・On the card, the number of people who scored an average of 80 points or more (1 person),
・I would like to display the number of times people scored an average of 80 points or higher in a graph.
How can I do it?

original data
--------------------------
Month,name,score
1,A,56
1,B,72
1,C,78
2,A,59
2,B,66
2,C,75
3,A,53
3,B,81
3,C,91
4,A,81
4,B,85
4,C,90
--------------------------

↓

Aggregated data
--------------------------
name,Total points,average score
A,249,62.25
B,304,76
C,334,83.5
--------------------------

？
・Cards (count of people with an average of 80 points or more)）
--------------------------

1

--------------------------

？
・Graph (count of people by number of times they scored an average of 80 points or higher)
--------------------------
number of times,Number of people
1,1
2,2
3,0
--------------------------

Thank you.

[ThxAlot]

[yyjp]

thank you.
This is truly the movement.

But it's difficult and I'm still trying to decipher it...

[qqqqqwwwweeerrr]

Hi @yyjp 

for your first problem, you can use this measure

CountNamesAbove80 = CALCULATE(DISTINCTCOUNT(Sheet4[name]), FILTER(ALL('Sheet4'[name]), CALCULATE(AVERAGE('Sheet4'[Score])) > 80))

For second problem i am not able to understand properly 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards

[yyjp]

thank you.
I was able to do the movement I wanted.