Exam 70-779 topic 1 question 59 discussion

Actual exam question from Microsoft's 70-779

Question #: 59
Topic #: 1

DRAG DROP -
You have a data model that contains a table named SalesOrders. SalesOrders has four columns named OrderId, SalesAmount, OrderDate, and Territory.
You plan to create a PivotChart that will display the percentage of SalesAmount for each Territory.
You need to create a measure to calculate the percentage of sales of each territory.
How should you complete the DAX formula? 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

Suggested Answer:

Reference:
https://chandoo.org/wp/percentage-of-another-value-pivot-table/

by BobJenkins at Feb. 21, 2020, 8:36 p.m.

Comments

Submit Cancel

CDL

4 years, 8 months ago

Answer is correct.

upvoted 4 times

...

BobJenkins

5 years, 3 months ago

Should this be SUM(SalesAmount)/ALL(SalesOrders)(Filter,ALL(SalesOrders)?

upvoted 1 times

ntonthat

5 years, 3 months ago

Nope. You want a division on the SUM(SalesAmount) against the total amount. Total amount = CALCULATE(SUM(SalesAmount), ALL(SalesOrders))) The ALL(SalesOrders) is a filter on the table SalesOrders such that it returns ALL the rows - it's more like an 'anti' filter if you will. Division = SUM(SalesAmount) / Total Amount = SUM(SalesAmount) / CALCULATE(SUM(SalesAmount), ALL(SalesOrders))

upvoted 23 times

...