PL-300 · Question #177
PL-300 Question #177: Real Exam Question with Answer & Explanation
Sign in or unlock PL-300 to reveal the answer and full explanation for question #177. The question stem and answer options stay visible for context.
Question
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. 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?
Options
- 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
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.