A simple solution to deal with ties RANKX (DAX)

SQL has a ROW_NUMBER function that will generate unique number even if the expression in the order by clause has a tie. This is not possible in DAX as RANKX cannot generate unique number if there is a tie therefore, we need to introduce some randomness to our expression Also, that the Top N or …

A simple solution to deal with ties RANKX (DAX) Read More »