RANK DAX Function
Returns the rank for the current context within the specified partition sorted by the specified order or on the axis specified.
Syntax
Parameter | Attributes | Description |
---|---|---|
Ties | Optional |
Function behavior in the event of ties. Skip – ranks that correspond to elements in ties will be skipped; Dense – all elements in a tie are counted as one. |
Relation | Optional |
A table expression where the RANK is computed. If omitted, OrderBy must be explicitly specified. |
OrderBy | Optional |
Columns that define how each partition is sorted. If omitted, Relation must be explicitly specified. |
Blanks | Optional |
Defines how to handle BLANK OrderBy values. Valid values include: KEEP, FIRST, LAST, SKIP. |
PartitionBy | Optional |
Columns that define how Relation is partitioned. |
MatchBy | Optional |
Columns that define how the current row is identified. |
Last update: Jun 10, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/dax/rank-function-dax