Which DAX formula should you use?

You have a Power BI model that contains the following two tables:
• Sales(Sales_ID, sales.date, sales_amount, CustomerlD)
• Customer(CustomerlD, 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[CustomerlD])

microsoft-exams

2 thoughts on “Which DAX formula should you use?

  1. This is wrong ans

    C is right ans
    C. RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.