Which Data Analysis Expressions (DAX) expression should you use?

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

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

B.
= [sales] / [Sales](ALLSELECTED(FactSales))

C.
= [sales] / CALCULATE([Sales], VALUES(FactSales[Year]),
VALUES(FactSales[Country]))

D.
= [sales] / [Sales](ALLEXCEPT(FactSales, FactSales[Year]))



Leave a Reply 2

Your email address will not be published. Required fields are marked *