Percentile Ranking Help Please

[Anonymous]

Hi Power BI Community, hope everyone is having a good day.
I am having problems with a formula, if someone could please help me 🙂
I am trying to find the 10th percentile for Per Capita Year over Year % excluding the Names with X.

Here is my data set: So find the 10th percentile Year over Year % Costs for Per Capita for Names with X in Use column.

The result I want to get is -15%

If anyone could please help me, I thank you in advance!

[Anonymous]

Forgot to add here is what it looks like if I did it manually:

[lbendlin]

What happened when you used PERCENTILEX.INC ?

[Anonymous]

Hi @lbendlin , It doesnt work, I get all infinity when I enter that.
I think its because there is no column for % change, and I have to use summerize column, but I cant figure out how to make it work. 
But I am very new to this so I could be very wrong.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...