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.

     

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

Hey Jkh30 ,

 

provide a pbix file containing sample data that still reflects your semantic model (tables, relationships, calculated columns, and measures), upload the file to OneDrive, Google Drive, or Dropbox and share the link. If you are importing the sample data from a spreadsheet instead of using the manual input method, share the spreadsheet as well. This is required to adapt the semantic model if necessary.

Do not forget to describe the expected result based on the sample data.

 

Regards,

Tom

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

Hi Tom, here is the url to download the PBIX and CSV file for datasource:

EPL Reports

Thank you for your help!