Question 177 of 388
Single answerNote: 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 scenarioYou have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. You plan to develop a Power BI model as shown in the Power BI Model 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?
AProduct Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)
✓BProduct Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Dense)
CProduct Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Skip)
DProduct Ranking= RANKX (ALL (`Product'), [SalesAmount], , Asc, Dense
✓
Correct Answer: B
Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Dense)
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.