Quintile based analysis Q1-Q5

Hi Guys!

Hoping you can help. Not sure why I am struggling a bit with this but cannot seemd to get it right.

Within my data table I have a "First contact resolution" column by 'Agent Performance" I am looking to provide the Agent Quintile based on thier FCR result.

Ie:

Agent 1 - 56%

Agent 2 - 41%

Agent 3 - 78%

Agent 4 - 98%

Agent 5 - 22%

I found the below on the forum but does not seem to be working like its suppose to, especially when I add in a 4th and 5th condition:

Quartile = 
var FirstQ = CALCULATE(PERCENTILE.INC(Table1[Column1], .25), ALL(Table1[Column1]))
var SecondQ = CALCULATE(PERCENTILE.INC(Table1[Column1], .50), ALL(Table1[Column1]))
var ThirdQ = CALCULATE(PERCENTILE.INC(Table1[Column1], .75), ALL(Table1[Column1]))
var ThisVal = Min(Table1[Column1])
return
IF(HASONEVALUE(Table1[Column1]), 
		IF(ThisVal <= FirstQ, 1,
			IF(ThisVal > FirstQ && ThisVal <= SecondQ, 2, 
				IF(ThisVal > SecondQ && ThisVal <= ThirdQ, 3, 4)
			)
		) 
) 

Any help witll be greatly appreciated 🙂

Regards