Câu 55: 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

You are developing a SQL Server PowerPivot workbook that sources data from a Microsoft Azure SQL 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?

1. A. = [Sales] / CALCULATE([Sales])
2. B. = [sales] / [Sales](ALLSELECTED(FactSales)) — đáp án hiện tại
3. C. = [sales] / CALCULATE([Sales], VALUES(FactSales[Year]), VALUES(FactSales[Country]))
4. D. = [sales] / [Sales](ALLEXCEPT(FactSales, FactSales[Year]))