DRAG DROP You are creating a Power BI model and report. You have a single table in a data model named Product. Product contains the following fields:
• ID
• Name
• Color
• Category
• Total Sales You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales. How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Available Steps (2)
Category
Total Sales You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales. How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Your Ordered Steps (0 of 2)
No steps added yet. Click "Add to Sequence" from the available steps above.
Explanation
Hotspot Solution:
Recommended Community Solution:
Answer: - TOPN - DESC * Explanation: - TOPN is specifically designed for ranking and filtering subsets of a table. - Using DESC ensures you get the products with the highest sales, not the lowest. - The result is a calculated table containing only those 8 rows, which we can then use in visuals or further modeling.
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
1
* Answer: - TOPN - DESC * Explanation: - TOPN is specifically designed for ranking and filtering subsets of a table. - Using DESC ensures you get the products with the highest sales, not the lowest. - The result is a calculated table containing only those 8 rows, which we can then use in visuals or further modeling.
