DAX/PowerBI Rank taking a varable/parameter into account

KristofferAJ — Tue, 17 May 2022 07:16:15 GMT

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:

Re: DAX/PowerBI Rank taking a varable/parameter into account

Anonymous — Fri, 20 May 2022 00:58:30 GMT

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

topic Re: DAX/PowerBI Rank taking a varable/parameter into account in DAX Commands and Tips

DAX/PowerBI Rank taking a varable/parameter into account

Re: DAX/PowerBI Rank taking a varable/parameter into account