Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Rank top 300 customers by commission earned by financial advisor

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

Thank you and kind regards

 

RankCustomer NameCommission Financial Advisor
1sss55yyy
2ddd44yyy
3fff32yyy
1fff77ttt
2iii76ttt
3uuu66ttt
1bbb99ppp
2jjj95ppp
3kkk94ppp
Status: Investigating

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

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
liyingjl
Regular Visitor

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
)

liyingjl_0-1660201090574.png

 

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
Community Support
Status changed to: Investigating

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

 

Best Regards,
Community Support Team _ Yingjie Li

Stanford08
Frequent Visitor

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-codeCustomer IDCommission Earned
ddd22221
ddd22222
ddd22220
ddd22219