exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 2 question 3 discussion

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

DRAG DROP -
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? 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.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: CALCULATE -
CALCULATE rvaluates an expression in a modified filter context.

Box 2: DIVIDE -
As a data modeler, when you write a DAX expression to divide a numerator by a denominator, you can choose to use the DIVIDE function or the divide operator (/
- forward slash).
When using the DIVIDE function, you must pass in numerator and denominator expressions.

Box 3: ALLSELECTED -
ALLSELECTED removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.
The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters. This function can be used to obtain visual totals in queries.
Example:
measure 'Reseller Sales'[Reseller Visual Total]=calculate(sum('Reseller Sales'[Sales Amount]), ALLSELECTED())
Reference:
https://docs.microsoft.com/en-us/dax/allselected-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
Sunny93
Highly Voted 4 years, 2 months ago
Correct answer is - Divide, Calculate, AllSelected.
upvoted 291 times
Canary_2021
3 years, 6 months ago
Agree! This is the correct answer.
upvoted 3 times
...
Zakriya
3 years, 7 months ago
yes, this is correct answer
upvoted 2 times
...
mirzotti
3 years ago
On exam 21-12-2021. I answered the same.
upvoted 1 times
...
dlring
3 years, 4 months ago
Agree. [Total Sales] is an existing measure in Sales Table that sums the total sales
upvoted 2 times
...
...
VR1
Highly Voted 4 years, 2 months ago
Divide, Calculate, AllSelected
upvoted 30 times
...
mlfattori
Most Recent 2 years, 5 months ago
Probado: Divide, Calculate, AllSelected
upvoted 2 times
...
claudeaboki
2 years, 6 months ago
Divide, calculate, allselected. I tested this and it correct
upvoted 1 times
...
Ashley090521
2 years, 9 months ago
on exam 3/1/2022
upvoted 1 times
...
Shan
2 years, 12 months ago
In exam 30/12/21
upvoted 1 times
...
kwanalytics
2 years, 12 months ago
On exam Dec. 27, 2021 - answered same with Divide, Calculate, AllSelected
upvoted 2 times
...
Thassika
3 years ago
Answer is - Divide, Calculate, AllSelected. please see below product%oftotal2 = DIVIDE([Total Sales],CALCULATE([Total Sales],ALLSELECTED(SA[Product Category Name]]])))
upvoted 4 times
...
aguilartu1
3 years, 1 month ago
on exam - Nov 11, 2021. my answers: DIVIDE CALCULATE ALLSELECTED
upvoted 4 times
...
nugi12
3 years, 2 months ago
wait why is calculate not the first one?
upvoted 4 times
Linda55
3 years ago
Calculate is needed for the calculation of Total Sales with the Allselected-Filter. Only after having both calcualted, the Total Sales and the Total Sales with the Allselected-Filter you divide the first by the second.
upvoted 2 times
...
Goooglegen
3 years ago
Example shown in MS documentation. Revenue % Total Channel = DIVIDE( SUM(Sales[Sales Amount]), CALCULATE(SUM(Sales[Sales Amount]),REMOVEFILTERS('Sales Order'[Channel]) ) )
upvoted 3 times
...
...
bilearner
3 years, 2 months ago
ans is Divide,calculate,AllSelected
upvoted 1 times
...
nowwin
3 years, 3 months ago
question in exam on 18th September
upvoted 3 times
Ihueghian
3 years, 2 months ago
I had this in my Exam 16/10
upvoted 2 times
...
...
Hope2000
3 years, 4 months ago
The correct answer is DIVIDE, CALCULATE, ALLSELECTED
upvoted 2 times
...
francis6170
3 years, 4 months ago
Got this in the exam - Aug 15, 2021.
upvoted 3 times
...
Ashud1
3 years, 4 months ago
#1 .Divide : Question is seeking % of Total Sales Hence Divide #2. Calculate : To return the expression on modified filter context #3. All Selected : To provide the filter argument to calculate function
upvoted 15 times
NargesRokni
3 years, 2 months ago
Thank you
upvoted 1 times
...
...
Popxm
3 years, 5 months ago
+ 1 Correct answer is - Divide, Calculate, AllSelected
upvoted 3 times
...
tramynt
3 years, 5 months ago
I did a test. Divide --> Calculate --> Allselected.
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