Returns the top N rows of the specified table.
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])
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).
See the remarks section to understand when the number of rows returned could possible be larger than n_value.
See the remarks section to understand when an empty table is returned.
table Any DAX expression that returns a table of data from where to extract the top 'n' rows.
Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.
order (Optional) A value that specifies how to sort orderBy_expression values, ascending or descending:
|0 (zero)||FALSE||Sorts in descending order of values of order_by.
This is the default value when order parameter is omitted.
|1||TRUE||Ranks in ascending order of order_by.|
A table with the top N rows of table or an empty table if n_value is 0 (zero) or less. Rows are not necessarily sorted in any particular order.
If there is a tie, in order_by values, at the N-th row of the table, then all tied rows are returned. Then, when there are ties at the N-th row the function might return more than n rows.
If n_value is 0 (zero) or less then TOPN returns an empty table.
TOPN does not guarantee any sort order for the results.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following sample creates a measure with the sales of the top 10 sold products.
= SUMX(TOPN(10, SUMMARIZE(Product, [ProductKey], "TotalSales", SUMX(RELATED(InternetSales_USD[SalesAmount_USD]), InternetSales_USD[SalesAmount_USD]) + SUMX(RELATED(ResellerSales_USD[SalesAmount_USD]), ResellerSales_USD[SalesAmount_USD]))