Fabric Analytics Engineer Associate Practice Test 2026 - Free Practice Questions and Study Guide

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards

From $12.50Unlock all

Session length

1 / 20

RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip ) describes which ranking behavior?

ranks the product names by Sales, with the largest sales values getting the smallest (e.g. 1,2,3) ranks, and where product names that have tied values get the same rank number

ranks the product names by Sales, with the largest values getting the smallest (e.g. 1,2,3) ranks, and when product names have tied values, then the next rank value, after a tie, is the rank value of the tie plus the count of tied values.

This examines how RANKX handles ties when ranking in descending order and using the Skip option. The function ranks products by their [Sales] value, and because of the DESC order, larger sales get better (smaller) ranks. The key part is the Tie behavior: with Skip, all tied items share the same rank, and the next rank value increases by the number of items that tied.

For example, imagine sales are 100, 90, 90, 80 for four products. The top product gets rank 1. The two tied products with 90 both get rank 2. Since there are two items tied, the next rank becomes 2 + 2 = 4, so the last product gets rank 4. This skipping of ranks after a tie is exactly what the Skip setting does.

That’s why this choice describes ranking by the largest values first, with ties sharing a rank and the next rank jumping forward by the count of tied items. If you used the Dense setting instead, the next rank would be 3, not 4, after a tie.

ranks the product names by Sales, with the smallest sales values getting the smallest (e.g. 1,2,3) ranks, and where product names that have tied values get the same rank number.

ranks the product names by Sales, with the smallest values getting the smallest (e.g. 1,2,3) ranks, and where product names that have tied values get unique rank numbers