How should you complete the DAX formula for the Percent measure?

DRAG DROP

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

You have measure named TotalSales that calculates the sum of Line Total.

You plan to create a PivotChart to display TotalSale 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 values 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.

NOTE: Each correct selection is wroth on point.

Answer: DIVIDE(TotalSales , CALCULATE(LineTotal, ALL(TotalSales), 0))

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
Ljupche
Ljupche
4 years ago

DIVIDE([TotalSales] , CALCULATE([TotalSales] , ALL(Sales)), 0)