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?
A. RANKX(ALL(Sales), SUMX(RELATEDTABLE(Customer), [Sales_amount]))
B. TOPN(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
C. RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
D. RANK.EQ(Sales[sales_amount], Customer[CustomerID])
You have a Power BI model that contains the following two tables:-> Sales(Sales_ID, sales_date, sales_amount, CustomerID
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You have a Power BI model that contains the following two tables:-> Sales(Sales_ID, sales_date, sales_amount, CustomerID
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!