Top N Grouping Problem

[Anonymous]

I have created a dynamic top N grouping following below YouTube (Top 10, Next 10 and The Rest).

Everything go fine as shown in Top Customer Analysis.

However, as the model would like to let user choose currency, and when I add the cur to the table, the grouping is not correct (as Top Customer Analysis with currency).

Even though I would like to add the ranking to the table, I got the same issue.

Can anyone help for this?

https://www.youtube.com/watch?v=0HR_h6YTjzc

File: https://drive.google.com/file/d/1XE-M3uGtv2EgDPc4V2rJ9QyEqHikqOQ9/view?usp=sharing

[Anonymous]

Hi @Anonymous ,

After test with your sample file, I found 'local currency' category contains multiple currency types. 

Obviously, it will face the issue of ranking sales between different currencies. (you can't direct do ranking on the different type of currency records)
I 'd like to suggest you convert these records to default currency type, then you can ranking and extract top n records based on the converted currency and add currency fields to display the original currency type of these records.

Regards,

Xiaoxin Sheng

[Anonymous]

Thanks for your advice

Unfortunately, the currency is a must (althoght i agree it is not a good idea)

After research, I am afraid it is impossble for Power BI to handle it.

I may seeking seeking for another presentation and just show top 10 customers and 11-20 customers