Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
Solved! Go to 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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
30 | |
15 | |
11 | |
10 | |
9 |