Microsoft
70-778 · Question #72
70-778 Question #72: Real Exam Question with Answer & Explanation
Sign in or unlock 70-778 to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.
Question
You have a Power BI model that contains the following two tables: Sales(Sales_ID, sales_date, sales_amount, CustomerID) Customer(CustomerID, First_name, Last_name) There is a relationship between Sales and Customer. You need to create a measure to rank the customers based on their total sales amount. Which DAX formula should you use?
Options
- ARANKX(ALL(Sales), SUMX(RELATEDTABLE(Customer), [Sales_amount]))
- BTOPN(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
- CRANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
- DRANK.EQ(Sales[sales_amount], Customer[CustomerID])
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.