RANK.EQ DAX Function (Statistical)
Returns the rank of a number in a column of numbers. If more than one value has the same rank, the top rank of that set of values is returned.
Syntax
RANK.EQ ( <Value>, <ColumnName> [, <Order>] )
| Parameter | Attributes | Description |
|---|---|---|
| Value |
The value to be ranked. |
|
| ColumnName |
A column in which the value will be ranked. |
|
| Order | Optional |
The order to be applied. 0/FALSE/DESC – descending; 1/TRUE/ASC – ascending. |
Return values
Scalar A single integer value.
A number indicating the rank of Value among the numbers in ColumnName.
Related functions
Other related functions are:
Last update: Oct 20, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/rank-eq-function-dax