Forum Discussion

Jkh30's avatar
Jkh30
Icon for Helper I rankHelper I
2 years ago
Solved

RANKX with Multiple Criterias

Hi everyone,   I have a case that I need to rank clubs based on their points each week and if the point between each clubs are the same, it needs to compare based on Greater Goal deficit. Also if t...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    This can be solved with the RANK() function.  To receive further help, share the donwload link of the PBI file.  Is Greater Goal deficit the same as GD?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Write this measure.  See the last column in the image.

    Measure = RANK(DENSE,FILTER(ALL(Club),Club[ClubID]<>BLANK()),orderby([Points],DESC,[Goal Deficit],desc,Club[Club Name],ASC))

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Write this measure.  See the last column in the image.

Measure = RANK(DENSE,FILTER(ALL(Club),Club[ClubID]<>BLANK()),orderby([Points],DESC,[Goal Deficit],desc,Club[Club Name],ASC))

Hope this helps.

 

Jkh30's avatar
Jkh30
Icon for Helper I rankHelper I
2 years ago

Splendid! Works beautifully!Thank you so much Ashish_Mathur . I mark this as solution.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    You are welcome.