Dynamically change a title based on a value.

I want to be able to dynamically change the title based on the average value within a table. I've tried the following logic

Status =  if(average(RESULT)> 4,"High Performing",if(average(RESULT)> 3.5 & average(RESULT)>4, "Satisfactory","Requires Review")) but not working.

The hoped outcome doesn't necessarly need to appear in a title, a card visual or table would equal work. The data is formatted in the following way: I'm simply taking the average "RESULT" of all rows (the table is filter though a drill through so unique MOD). Any help / advise greatly appreacited.

MOD      SITE      QUESTION      RESULT

123         BUS       Q1                  4

123         BUS       Q1                  3

123         BUT       Q2                  1

123         BUT       Q2                  5

123         BUS       Q1                  4

123         BUY       Q1                  3

123         BUY       Q1                  4

123         BUY       Q1                  2