Trying to do some Scoring using Percentiles

[WizardWalksBy]

Struggling with something that seemed to be simple before DAX... beginner here trying to convert a
column of percentages (fill rates) for our supplier base into percentiles for scoring purposes.

Supplier FillRate% Percentile
A               16.5%        ?
B                99.5%       ?
C                 85.8%      ?
D                68.5%       ?

I've spent a day now researching the DAX Percentile functions and can't seem to get that Percentile column
populated. Any help would be so appreciated!
Thanks

[OwenAuger · Accepted solution]

@WizardWalksBy

Sounds like you're wanting the equivalent of Excel's PERCENTRANK function.

Have a look at this thread for some sample DAX you could adapt:

http://community.powerbi.com/t5/Desktop/PERCENTRANK-Inclusive/m-p/81208

In my (@OwenAuger) post there is some code that should replicate Excel's function including handling ties, which was quite long-winded to be honest.

@v-sihou-msft's post has a simpler formula that works fine without ties.

Cheers,

Owen

[WizardWalksBy]

Exactly what I was looking for, thanks a million!!