Câu 15: 70-778: Analyzing and Visualizing Data with Microsoft Power BI

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?

1. A. RANKX(ALL(Sales), SUMX(RELATEDTABLE(Customer), [Sales_amount])) — đáp án hiện tại
2. B. TOPN(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
3. C. RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
4. D. RANK.EQ(Sales[sales_amount], Customer[CustomerID])