Which statement accurately describes the DAX measure RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip )?

Which statement accurately describes the DAX measure RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip )?

• A. RANKX ranks products by Sales in ascending order, giving rank 1 to the smallest Sales.
• B. RANKX ranks the product names by Sales, with the largest values getting the smallest ranks, and when there are ties, the next rank value is the tie rank plus the count of tied values.
• C. RANKX computes the cumulative total of Sales across all products.
• D. RANKX ignores ties and assigns ranks based on alphabetical order of Product Name.

Answer: (B)

RANKX computes a ranking of the given expression across a table. In this case, ALL('Product'[Product Name]) provides the full set of products (no filter by product name), and [Sales] is the value being ranked. With DESC, the largest sales come first, so the top seller gets rank 1. The Ties parameter Skip means that when two or more products have the same sales, they share the same rank, and the next distinct sales value receives a rank that skips ahead by the number of tied items. For example, values 100, 90, 90, 80 yield ranks 1, 2, 2, 4. This matches the description in the correct option.

RANKX computes a ranking of the given expression across a table. In this case, ALL('Product'[Product Name]) provides the full set of products (no filter by product name), and [Sales] is the value being ranked. With DESC, the largest sales come first, so the top seller gets rank 1. The Ties parameter Skip means that when two or more products have the same sales, they share the same rank, and the next distinct sales value receives a rank that skips ahead by the number of tied items. For example, values 100, 90, 90, 80 yield ranks 1, 2, 2, 4. This matches the description in the correct option.