Ranking Column required based on more than 1 column in the dataset

[atin]

Hi All  - please find attached a list of all the premier league teams and the rankings, based on Points, Match Played and Goals Difference(GD)

I would like to create a Ranking Column to mirror the attached spreadsheet example. I have highlighted some of the teams in Yellow which have similar points however the ranking is based on GD, Points & Matches Played

I had originally created a ranking measure

 = RANKX( ALLSELECTED( 'TeamStatsTable'[Team] ) , CALCULATE( SUM ('TeamStats'[Points]  )  ) ) 

However this measure only considers the points column and I would like help on how to incorporate the other columns in my measure

Many thanks

 Ranking

[vanessafvg · Accepted solution]

this is quite a useful article https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/#

[Fowmy · Accepted solution]

@atin 

In addition to the article suggested by @vanessafvg , if you like to try a simple Power Query solution when you need a static ranking, try the following:

Sort the Pts and GD columns Descending and Played Ascending order then add an index column with 1

[vanessafvg · Accepted solution]

this is quite a useful article https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/#