How to calculate percentile for selected group

[BhaveshSavla]

HI,

In the given link where based on employee id Percentile is calculated but i am unable to calculate Percentile for a Value in a Sub-Group. Pls help.

https://goodly.co.in/calculate-percentile-in-power-bi/

[BhaveshSavla]

Any help pls.

[BhaveshSavla]

Experts,

Pls help on the below situation.

[BhaveshSavla]

Hi,

In the sample file, percentile calculating for individual employee basis (With in the Sub-Group) where as i want percentile on the basis of only sub group i.e. "Occupation". For eg: in "Teacher" ocupation what is the % of people are above average and below average salary. 

[v-yanjiang-msft]

Hi @BhaveshSavla ,

In the link you provided, I see it already provide the solution of calculating percentile for a value in a sub-group.

Have you tried the solution? Doesn't it work for you? 

Best Regards,
Community Support Team _ kalyj