Drag and Drop Question
You are creating a Power Bi model and report.
You have a single table in a data mode) 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 coned 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.

Correct Answer:

Explanation:
Box 1: TOPN
TOPN returns the top N rows of the specified table.
Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>,
[<order>]]ג€¦])
Box 2: DESC
Descending order to get the highest values first.
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax