ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 2 question 6 discussion

Actual exam question from Microsoft's DA-100
Question #: 6
Topic #: 2
[All DA-100 Questions]

HOTSPOT -
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: TOPN -
TOPN returns the top N rows of the specified table.

Box 2: SUMMARIZE -
SUMMARIZE returns a summary table for the requested totals over a set of groups.

Box 3: DESC -
Sort in descending order.
It is last in the TOPN command.
TOPN syntax:
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]ג€¦])
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax
by stokazz at March 11, 2021, 8:41 p.m.

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
Submit Cancel
stokazz
Highly Voted 4 years, 3 months ago
Correct! TopN, Summarize, Desc
upvoted 90 times
mirzotti
3 years, 5 months ago
On exam 21-12-2021. TopN, Summarize, Desc is correct
upvoted 2 times
...
...
Lilli
Highly Voted 4 years, 1 month ago
Top 100 Customers = TOPN(100, SUMMARIZE(FactTransaction, FactTransaction[Customer ID], "Sales", Sum(FactTransaction[Sale])), [Sales], DESC)
upvoted 20 times
...
claudeaboki
Most Recent 3 years ago
Tested. TOPN,SUMMARIZE, DESC
upvoted 2 times
...
Leonardocc
3 years, 2 months ago
Correct!!!
upvoted 1 times
...
Ashley090521
3 years, 3 months ago
on exam 3/1/2022
upvoted 1 times
...
Milq
3 years, 4 months ago
TopN, Summarize, Desc Correct Answer!
upvoted 1 times
...
Pritam85
3 years, 4 months ago
Correct answer - TopN, Summarize, Desc
upvoted 2 times
...
kwanalytics
3 years, 5 months ago
On exam Dec 27, 2021 - answered same as choices here TopN, Summarize, Desc
upvoted 1 times
...
haepoeg
3 years, 5 months ago
topN, summarize, desc
upvoted 2 times
...
aguilartu1
3 years, 7 months ago
on exam - Nov 11, 2021.
upvoted 3 times
...
francis6170
3 years, 10 months ago
Got this in the exam - Aug 15, 2021.
upvoted 5 times
...
Champikilo
4 years, 1 month ago
TopN, Summarize, Asc is the correct answer.
upvoted 2 times
Charley92
3 years, 11 months ago
It should be DESC which gives from the highest order
upvoted 7 times
...
...
SuzyQt
4 years, 1 month ago
If you are looking for the highest wouldn't it be ASC.
upvoted 2 times
MachineGunSquirrel
4 years, 1 month ago
ASC starts from lowest and goes to highest, DESC starts high and goes low. If you want the top highest, you'll want DESC.
upvoted 12 times
...
...
kwamek
4 years, 1 month ago
Correct
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