Forum Discussion
Jkh30
Helper I
Helper IRANKX 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...
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?
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
Super User
Super UserHi,
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?
Jkh30Helper I
Helper IHi Ashish_Mathur here is the url to download the PBIX and CSV files as the data source:
EPL Reports
Thank you for your help!
- Ashish_Mathur
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
Splendid! Works beautifully!Thank you so much Ashish_Mathur . I mark this as solution.
- Ashish_Mathur
You are welcome.