topic Re: RANKX function with ALL in Desktop

RANKX function with ALL

Anonymous — Wed, 03 Apr 2019 12:30:08 GMT

Hi all,

I need your help on this please:

I 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.
I need to create a measure to rank the customers based on their total sales amount.

Which DAX formula should I use?

Is this the right formula: RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount])) ?

Many thanks.

Re: RANKX function with ALL

mussaenda — Wed, 03 Apr 2019 13:05:06 GMT

You may refer at this tutorial

Re: RANKX function with ALL

v-cherch-msft — Thu, 04 Apr 2019 05:20:15 GMT

Hi Anonymous

You may try below measure:

Measure =
RANKX ( ALL ( Customer ), CALCULATE ( SUM ( Sales[sales_amount] ) ) )

Regards,

Re: RANKX function with ALL

Anonymous — Wed, 22 May 2019 14:13:35 GMT

Anonymous wrote:
Hi all,

I need your help on this please:
I 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.
I need to create a measure to rank the customers based on their total sales amount.
Which DAX formula should I use?
Is this the right formula: RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount])) ?

Many thanks.

I think correct ans is RANKX(ALL(Sales), SUMX(RELATEDTABLE(Customer), [Sales_amount])).

Bez question is asking to create a measure in Sales Table. Correct me If I am wrong?