Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
KristofferAJ
Helper III
Helper III

DAX/PowerBI Rank taking a varable/parameter into account

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 exampledata example

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors