Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a measure to rank total sales by product.
The results must appear as shown in the following table.
Which DAX formula should you use?
A . Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)
B . Product Ranking= RANKX (ALL, (‘Product’), [SalesAmount], , DESC, Dense)
C . Product Ranking= RANKX (ALL, (‘Product’), [SalesAmount], , DESC, Skip)
D . Product Ranking= RANKX (ALL (‘Product’), [SalesAmount], , Asc, Dense
Answer: B
Explanation:
References: https://msdn.microsoft.com/en-us/library/gg492185.aspx
Leave a Reply