The first parameter is a DAX table over which the expression is evaluated. The second parameter, <expression>, is a numerical value that the ranking will be sorted by. The <value> parameter is not often used as its purpose is to return a single scaler value whose rank is to be found. There are not many use-cases for this. The <order> parameter allows you to determine whether the return ranking should be sorted ascending or descending. Finally, the <ties> parameter doesn’t actually break ties but instead determines whether there should be gaps in your ranking in the event of a tie or whether the next value is sequential.

A Look At Our Data

Sales ranking tables are commonly used by companies to identify top performers, provide transparency, and spur competition among sales reps. In this example we are using a dataset that house information about projects being sold by a sales team. As you can see, we have a list of all sold projects, which sales rep sold the project, how many units were sold, and the project revenue.