You are developing a SQL Server PowerPivot workbookthat sources data from a SQL Azure database.
The PowerPivot model includes a single table named FactSales that consists of four columns named Year,
Country, Product, and Revenue.
The model includes the following two measures :
.Sales:=SUM(FactSales[Revenue])
.Sales %:=[Sales] / CALCULATE([Sales], ALL(FactSales))
In Microsoft Excel 2010 you create the following PivotTable report.
Users report that the Sales % measure computes an incorrect ratio.
The measure should meet a requirement to compute a ratio over all visible sales values defined by the query
filters.
The Grand Total value for the Sales % measure should equal 100%.
You need to fix the Sales % measure to meet the requirement.
Which Data Analysis Expressions (DAX) expression should you use?
A.
=[Sales] / CALCULATE([Sales], VALUES(FactSales[Year]), VALUES(FactSales[Country]))
B.
=[Sales] / CALCULATE([Sales])
C.
=[Sales] / [Sales](ALLEXCEPT(FactSales, FactSales[Year]))
D.
=[Sales] / [Sales], (ALLSELECTED(FactSales)
[Sales] / CALCULATE([Sales], ALLSELECTED(FactSales))