Halloween Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

Note: This question is a part of a series of questions that present the same...

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

PL-300 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now PL-300 pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"