exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 37 discussion

Actual exam question from Microsoft's PL-300
Question #: 37
Topic #: 2
[All PL-300 Questions]

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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Namenick10
Highly Voted 2 years, 7 months ago
TOPN & DESC
upvoted 74 times
...
gtc108
Highly Voted 2 years, 6 months ago
TOPN, DESC
upvoted 16 times
...
rcaliandro
Most Recent 8 months, 1 week ago
The answer is correct TOPN, DESC
upvoted 2 times
rcaliandro
8 months, 1 week ago
Tested =)
upvoted 1 times
...
...
Igetmyrole
1 year, 7 months ago
TOPN and DESC are the answers. Top 8 products = TOPN(8, 'Product', 'Product'[Total Sales], DESC)
upvoted 3 times
...
rgabage
1 year, 8 months ago
TOPN, DESC
upvoted 2 times
...
LambdaBld
2 years ago
Answer is correct
upvoted 2 times
...
RazaTheLegend
2 years ago
TOPN & DESC
upvoted 3 times
...
vishal10
2 years, 4 months ago
TOPN, DESC
upvoted 3 times
...
iccent2
2 years, 4 months ago
TopN and then DESC
upvoted 3 times
...
reyn007
2 years, 4 months ago
TOPN, DESC
upvoted 3 times
...
lukelin08
2 years, 4 months ago
Answer is TOPN & DES
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago