How should you complete the DAX formula?

DRAG DROP

You have a data model that contains a table named SalesOrders has four columns named Orderld, 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 value to the correct targets. Each value may be used once, more than once, or not at all. You need to drag the split bar between panes or scroll to view content.

Answer: SUM([SalesAmount) / ALL(SalesOrders) /(FILTER , ALL(SalesOrders))

Latest 70-779 Dumps Valid Version with 101 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
1 Comment
Inline Feedbacks
View all comments
mohroshdi1983
mohroshdi1983
5 years ago

Correct Answer is SUM([SalesAmount]) / CALCULATE (SUM([SalesAmount]) , ALL(SalesOrders) )