Top 5 Customer in Power BI

[TG2812]

Hi fellows!

Background:

• I'm trying to do a dynamic top 5 customer based on the quantity of sales they've made.
• I created a measure Total_Sales using the "Qty" column of table "Sales".
• Important: the measure Total Sales will be part of the table "Sales". The argument "Sales[Total_Sales] does not even pop up from the drop down suggestion list.

Problem:
When I'm typing the DAX formula "Rank = RANKX(ALL(Sales[Customer name],Sales[Total_Sales],DESC))", it does not return anything.

Any idea what I'm doing wrong?

Thank you in advance for looking at my case.

 

[bkjohn2016]

[COLOR=#000000][FONT=Consolas]Rank = RANKX(ALL(Sales[Customer name]),
SUM(Sales[Total_Sales]),DESC)[/FONT][/COLOR]