Microsoft
70-778 · Question #72
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…
The correct answer is C. RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount])). https://msdn.microsoft.com/query-bi/dax/rankx-function-dax
Model and Visualize Data by Using Power BI Desktop
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])
How the community answered
(39 responses)- A5% (2)
- B13% (5)
- C79% (31)
- D3% (1)
Explanation
Topics
#RANKX#DAX measures#RELATEDTABLE#customer ranking
Community Discussion
No community discussion yet for this question.