Rank SKIP paramter will not skip after ties

[banditx421]

I am trying to use the rank function to rank weekly points.  I want the ranking to skip a value after ties.  I entered the SKIP parameter but it is not skipping after ties.  See screenshot below.  What am I doing wrong?  If i put the 'All Scores' table as the second parameter I get a circular reference error.  

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

RANK function (DAX) - DAX | Microsoft Learn

Weekly Rank CC =
RANK (
    SKIP,
    SUMMARIZE (
        'All Scores',
        'All Scores'[Team ID],
        'All Scores'[Total Points],
        'All Scores'[Matchup Week]
    ),
    ORDERBY ( 'All Scores'[Total Points], ASC ),
    ,
    PARTITIONBY ( 'All Scores'[Matchup Week] )
)

[banditx421]

Thank you, this worked perfectly.  If you have an explanation for why my original formula below doesn't work it would be appreciated as well.  

Weekly Rank = rank(SKIP, , orderby([Total Points]), LAST, PARTITIONBY('All Scores'[Matchup Week]))

Here is my model, although the DAX formula above is a calculated column that only relies on data from the table the column is created in.