Forum Discussion
Rank SKIP paramter will not skip after ties
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.
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] ) )
2 Replies
- Jihwan_Kim
Super User
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] ) )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.
