Microsoft
70-778 · Question #12
70-778 Question #12: Real Exam Question with Answer & Explanation
Sign in or unlock 70-778 to reveal the answer and full explanation for question #12. 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. (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?
Exhibit
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 70-778 to see the answer
You've previewed enough free 70-778 questions. Unlock 70-778 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.