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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors