ORDERBY DAX Function (Filter)

The expressions and order directions used to determine the sort order within each partition. Can only be used within a Window function.

Syntax

ORDERBY ( [<OrderBy_Expression> [, [<OrderBy_Direction>] [, <OrderBy_Expression> [, [<OrderBy_Direction>] [, … ] ] ] ] ] )

Parameter	Attributes	Description
OrderBy_Expression	Optional Repeatable	An expression used to determine the sort order.
OrderBy_Direction	Optional Repeatable	A value that specifies how to sort OrderBy_ColumnName values, ascending or descending: Value: DESC. Alternative value: 0(zero)/FALSE. Sorts in descending order of values of OrderBy_ColumnName . Value: ASC. Alternative value: 1/TRUE. Sorts in ascending order of values of OrderBy_ColumnName . This is the default value if OrderBy_Direction is omitted.

Parameter

Attributes

Description

OrderBy_Expression

Optional
Repeatable

An expression used to determine the sort order.

OrderBy_Direction

Optional
Repeatable

A value that specifies how to sort OrderBy_ColumnName values, ascending or descending:

Value: DESC. Alternative value: 0(zero)/FALSE. Sorts in descending order of values of OrderBy_ColumnName .
Value: ASC. Alternative value: 1/TRUE. Sorts in ascending order of values of OrderBy_ColumnName . This is the default value if OrderBy_Direction is omitted.

This function does not return a value.

This function can only be used within a window function expression (INDEX, OFFSET, WINDOW).

Learn more about ORDERBY in the following articles:

Introducing window functions in DAX
In December 2022, DAX was enriched with window functions: INDEX, OFFSET, and WINDOW. This article introduces the syntax and the basic functionalities of these new features. » Read more

Other related functions are:

Contributors: Alberto Ferrari, Marco Russo