How to calculate avg of a column (number) then return it based on conditions (text)

[Anonymous]

Would like to calculate the average of a column ("Score") then return it based on conditions (text).

Score

1

5

7

9

10

3

The average would be 5.8333

However, would like it to refer to the rating_criteria info (below)

	Rating_Criteria
8.1 to 10	World Class
7.6 - 8.0	Excellent
7.1 - 7.5	Good
6.5 - 7.0	Average
1.0 - 6.4	Under-performing

and return as per the criteria which to show "Under-Performing"  please 🙂 

[CNENFRNL]

Excel formlua is concise enough to cope with this,

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try this

Measure = 
VAR _avg=AVERAGE('Table'[Score])
return SWITCH(TRUE(),_avg>8.1,"world class",_avg>7.5,"Excellent",_avg>7.0,"Good",_avg>6.4,"Average","Under-performing")

[Anonymous]

Worked like a charm! 
Thank you 

[ryan_mayu]

you are welcome