Note: This question is part of a series of questions that use 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 button.)



You plan to develop a Power BI model as shown in the Power BI Model exhibit.

(Click the Exhibit button.)



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(ALL(Product), [SalesAmount],,Asc, Dense)

B. Product Ranking = RANKX(ALL(Product), [SalesAmount],,DESC, Skip)

C. Product Ranking = RANKX(ALL(Product), [SalesAmount],,DESC, Dense)

D. Product Ranking = RANKX(Product, [SalesAmount],,DESC, Skip)

References: https://msdn.microsoft.com/en-us/library/gg492185.aspx