In the DAX TOPN expression used in the visual, what does TOPN(1001, __DS0Core, [Sales], 0, 'Company'[Manufacturer], 1) do?

In the DAX TOPN expression used in the visual, what does TOPN(1001, __DS0Core, [Sales], 0, 'Company'[Manufacturer], 1) do?

• A. TOPN returns the smallest 1001 rows by Sales
• B. TOPN returns the top 1001 rows by Sales, with a secondary sort on Manufacturer
• C. TOPN filters to 1001 products only
• D. TOPN returns a random sample

Answer: (B)

TOPN picks a subset of rows from a table by ordering them with one or more sort keys and returning the first N rows. In this expression, the table is __DS0Core. The primary sort key is Sales, and the 0 indicates a descending order, so rows with larger Sales come first. If two rows tie on Sales, a secondary sort is applied using the Manufacturer column from the Company table, with 1 indicating ascending order. So the result is the top 1001 rows by Sales, and ties are resolved by ordering manufacturers alphabetically. It’s not a random sample or a simple filter to 1001 products; it’s a deterministic top-N selection based on the specified sort criteria.

TOPN picks a subset of rows from a table by ordering them with one or more sort keys and returning the first N rows. In this expression, the table is __DS0Core. The primary sort key is Sales, and the 0 indicates a descending order, so rows with larger Sales come first. If two rows tie on Sales, a secondary sort is applied using the Manufacturer column from the Company table, with 1 indicating ascending order. So the result is the top 1001 rows by Sales, and ties are resolved by ordering manufacturers alphabetically. It’s not a random sample or a simple filter to 1001 products; it’s a deterministic top-N selection based on the specified sort criteria.