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.

View Answer

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