Hello all,
So i've had this question for a while now, but never got to find a correct way of doing this.
Context :
I have an "Evaluations" table, that has test results from multiple establishments.
I have to return the average results for each establishments.
The results are on a scale from 0 to 20.
Pretty easy so far.
Problem :
In a matrix visual, I need to show the average for each establishment, not as number, but as a letter.
For example, if the average of an establishment is 11 out 20, I need to show "C+". If the average is 17 out of 20, I need to show "A". And so on.
For now, I have had to do it all manually with multiple IF functions. It works, but this seems like a terrible solution, espacially if I have to had more IF later...
Isn't there any way to do this dynamically ?
So far, I have tried with less values, by first building a correspondance table like the following :
| Possible_Results | What_I_Want_To_See |
| 1 | A |
| 2 | B |
| 3 | C |
4 | D |
5 | E |
Then, I tried doing something like this in a measure :
If(
AVERAGE([Establishment_Result]) in [Possible_Results]
,[What_I_Want_To_See]
)
I also tried with SWITCH(), but it doesn't work. I haven't found any threads with similar problems, and I really can't think of anything alse I can try right now. Any clues would be appreciated !
Thank you in advance !
