The number of rows to return. It is any DAX expression that returns a single scalar value, where the expression is to be evaluated multiple times (for each row/context). If a non-integer value (or expression) is entered, the result is cast as an integer.

table

Any DAX expression that returns a table of data from where to extract the ‘n’ sample rows.

orderBy_expression

(Optional) Any scalar DAX expression where the result value is evaluated for each row of table.

order

(Optional) A value that specifies how to sort orderBy_expression values, ascending or descending:

value

alternate value

Description

0 (zero)

FALSE

Sorts in descending order of values of order_by.

This is the default value when order parameter is omitted.

A table consisting of a sample of N rows of table or an empty table if n_value is 0 (zero) or less. If OrderBy arguments are provided, the sample will be stable and deterministic, returning the first row, the last row, and evenly distributed rows between them. If no ordering is specified, the sample will be random, not stable, and not deterministic.