Exam 70-779 topic 1 question 39 discussion

Actual exam question from Microsoft's 70-779

Question #: 39
Topic #: 1

DRAG DROP -
You have a model that contains the following table named Sales.

You have a measure named TotalSales that calculates the sum of LineTotal.
You plan to create a PivotChart to display TotalSales for each category and the percent of total sales for each category as shown in the following exhibit.

How should you complete the DAX formula for the Percent measure? To answer, drag the appropriate fields to the correct areas. Each field 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:

References:
https://www.fourmoo.com/2017/07/18/power-bi-dax-measures-for-excel-based-of-column-total-or-of-row-total/

by CibrevN at June 2, 2020, 5:14 p.m.

Comments

Submit Cancel

lyniguez

Highly Voted 4 years, 9 months ago

solution is correct

upvoted 6 times

FrdFrd

4 years, 5 months ago

Provided solution is correct but there are some issues with the parentheses

upvoted 1 times

...

kannn

Most Recent 4 years, 7 months ago

what is the correct answer??

upvoted 1 times

...

CDL

4 years, 8 months ago

correct. https://docs.microsoft.com/en-us/dax/divide-function-dax https://docs.microsoft.com/en-us/dax/calculate-function-dax https://docs.microsoft.com/en-us/dax/all-function-dax

upvoted 1 times

...

Tzozo

4 years, 10 months ago

Divide([TotalSales]/[UnitPrice], CALCULATE( [TotalSales], ALL('Sales')))

upvoted 3 times

hfgirona

4 years, 7 months ago

Do not works. Solution is correct.Tested.

upvoted 1 times

...