DAX/PowerBI Rank taking a varable/parameter into account

[KristofferAJ]

Hi,

I'm working on a ranking/scoring system and I'm missing the "PERCENTRANK.INC" function in powerBI. Instead I received great input on this formula which is the closest I can get.

Score = DIVIDE ( RANKX ( FILTER ( 'Table', NOT ( ISBLANK ( [Sold amounts] ) ) ), [Sold amounts], , ASC ) - 1, COUNTROWS ( FILTER ( 'Table', NOT ( ISBLANK ( [Sold amounts] ) ) ) ) - 1 )

I really want to have the formula to take the type of "Fruit" into account in my scoring/ranking. In short each fruit should be scored seperately, with a range per fruit sold.

Could this somewho be done with a variable (VAR)?

Example of data:

data example

[v-shex-msft · Accepted solution]

HI @KristofferAJ,

Maybe you can take a look at the following link about the Dax equivalent of PERCENTRANK.INC function:

[Solved] DAX equivalent of Excel PERCENTRANK.INC per category - Local Coder

Regards,

Xiaoxin Sheng