Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RANKX function with ALL

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, ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may try below measure:

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

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

You may try below measure:

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

Regards,