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
Correct Answer is SUM([SalesAmount]) / CALCULATE (SUM([SalesAmount]) , ALL(SalesOrders) )