Top N Ranking in Concentration Chart

[JH]

Hello,

I'm trying to create a concentration chart, ranking our customers according to their revenue. I should look somehow like this: 

I need to use some sort of formula, such as: TOPN or RANKX to always have automatically the top 5 vendors pictured. I further need to filter it by Country. 

However, I can't get my head around the TOPN Formula as I keep making syntax mistakes.

The data used is the following:

Vendor_name in the vendor table

Total_revenue in the revenue table 

(both tables are correctly joined)

What I need is that the vendor_name ranks themselves according to the Total_revenue collumn. 

Can smn help me out? 

(No, I can't just use the TOP N Filter 🙂 )

Thank you!  

[v-yuta-msft]

Hi JH,

Could you give more details about your tables and measures you are using? In addtion, you said "vendor_name ranks themselves according to the Total_revenue collumn", vendor_name is a table, right? So which column do you want to rank by column [Total_revenue]? Are there some other columns should be used as category column to be group by? Please clarify more details about your expected requirement.

Regards,

Jimmy Tao

[JH]

Hi Jimmy,

Thanks for your reply and sorry for my late answer! 

I want the different vendors name (vendor being the table, and name the measure) ranked by total revenue (Internal Revenue being the Table and Total internal revenue the measure). I do not need any extra category for now 🙂