Scores split

[Danieltoro]

Hi. I need to split a set of scores as attached. I can use IFS but is there a better way of doing it? Just wondering.
Also, how would I achieve it in DAX best? Many thanks.

A score of 0 means a benchmark is “Not achieved”. A score of 1-99 means a benchmark is “Partially achieved” and a score of 100 means a benchmark is “Achieved”.

 

[Danieltoro]

Also, the complication here (to me) is the between 1 and 99

 

[Danieltoro]

I have tried the below in excel but it doesn't seem to like it;
=IFS([@bm1]=0,"Not Achived",(AND([@bm1]>0,[@bm1]>100),"Partially Achived",[@bm1]=100,"Achieved"))

 

[AliGW]

How/where do you want the results? Is this it?

In J2 copied across and down:

=LOOKUP(A2,{0,1,100},{"NA","PA","A"})