Need help in calculating percentile

[Reddypk]

two colums, Trial and enrollment number 
I need to calculate percentile for indevedual trial ID, Example Trial 1234 has 7 entries and the percentile column shoul get percentile.
highest enrolled number for trial 1234 will ger percentile as 1 and the lowest will get 0.9 or 0.5 or 0.4 whatever compared to hightst enrolled number for the specific tril ID

Trial ID	Enrolled	Percentile
1234	4
1234	10
1234	24
1234	43
1234	64
1234	85
1234	109	1
1235	10
1235	15
1235	20
1235	45
1235	50	1

[v-zhangti · Accepted solution]

Hi, @Reddypk 

You can try the following methods.

Percentile = 
var _N1 = MAXX(FILTER(ALL('Table'),[Trial ID]=EARLIER('Table'[Trial ID])),[Enrolled])
return 
DIVIDE([Enrolled],_N1)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.