Rank top 300 customers by commission earned by financial advisor

[Stanford08]

Good day, 
How do i Rank top 3 customers by commission earned by financial advisor, as shown below? 

Thank you and kind regards

Rank	Customer Name	Commission	Financial Advisor
1	sss	55	yyy
2	ddd	44	yyy
3	fff	32	yyy
1	fff	77	ttt
2	iii	76	ttt
3	uuu	66	ttt
1	bbb	99	ppp
2	jjj	95	ppp
3	kkk	94	ppp

[liyingjl]

You can try to create a column like this:

Rank = 
RANKX(
    FILTER(
        ALL('Table'),
        'Table'[Financial Advisor] = EARLIER('Table'[Financial Advisor])
    ),
    'Table'[Commission ],,DESC,Dense
)

In addition, if you have more questions about DAX formulas, you can create new posts on Desktop Forum or DAX Commands and Tips Forum which could get fast help:

Home - Microsoft Power BI Community

Regards

[v-yingjl]

Whether this issue has been resolved, if this issue has been resolved, will close this thread. 

Best Regards,
Community Support Team _ Yingjie Li

[Stanford08]

Hi liyingjl,

Thank you for this.

Im still having an issue. Works partly

How do I work around a circular dependency error, when I try sum the different commissions earned per customer?

Rank = RANKX( FILTER( ALL('Table'), 'Table'[Financial Advisor] = EARLIER('Table'[Financial Advisor]) ), calculate(sum('Table'[Commission ])),,DESC,Dense )

Also the rank seems to collapse when I bring in other columns into the table.

C-code	Customer ID	Commission Earned
ddd	222	21
ddd	222	22
ddd	222	20
ddd	222	19