RANK top 10 by different categories

[Aydeedglz]

Hi I have a table where I have "Region", "Customer", "Past Due", "Total"

I want to see by "Past Due" the top 10 customers only showing in the table, and I want to see from where region do they belong, the issue is when I want to filter top N it gives me Top 10 for North America, Top 10 for Europe, Top 10 for Asia, etc... But I want to see the top 10 by past due only, it doesn't metter the region, just which cutomer and where is it from.

This is what I have

This is what I want

This is what I am having

Any idea how? thanks

[Aydeedglz]

Hi,

Is still the same 

I need the top 10 customers by PAST DUE, but I can't sort top 10 because I have 4 columns:

Region | Customer | Past Due | Over 90

I need only 10 rows, see in the table 10 rows, NO MORE. And I need the top 10 customers with more Past Due. BUT the filter in power bi is giving me Top 10 customer BY REGION, I DO NOT need by region, just Top 10 customers

I need to see: 10 rows

What I see: 10 rows BY region (I have NA, EUROPE, ASIA, ASIA2) so I am seeing 40 rows in total. I ONLY NEED 10 INDEPENDET OF THE REGION 

Example:

Region  |  Customer  |  Past Due  | Over 90

NA          Customer 1     563.18        100

NA          Customer 22   558.19         98

EUROPE  Customer 8     498.88         95

ASIA1      Customer 5     448.01         88

ASIA2      Customer 39   422.65        82

ASIA2      Customer 99   420.97         75

EUROPE  Customer 78   341.77         71

ASIA        Customer 16   310.63         70

NA           Customer 65   301.01         68

NA           Customer 81   299.48         66

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached the PBI file.

Hope this helps.

[Aydeedglz]

I was analyzing my data and I noticed an error is ranking by the total per customer but it need to group by customer in the region. For example 

Only customer:

Customer 1 total 100

By region

Customer 1 total 100

Europe 50

NA 25

Asia 1 15

Asia 2 10

So ranking should look like this:

Europe Customer 1 50 - Ranking 1

Not as total of the customer but total as for cutomer and region as one

[Ashish_Mathur]

I am not clear at all about this requirement.

[Aydeedglz]

Is workin! thanks! I have seen a lot of videos and read a lot of articules and non was able to solve the problem if we have a second category, but we don't want to use it in the ranking, just as reference! Really thanks 🙂

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[amitchandak]

@Aydeedglz ,

2 column top N = Sumx(Keepfilters( TOPN(10, SUMMARIZE(ALLSELECTED('Table'), 'Table'[region], 'Table'[Customer Name]), calculate(Sum(Table[Total due])) ,DESC)),calculate(Sum(Table[Total sue])))

if you need top 10 customer inside each region

Sumx(keepfilters(topn(10, allselected('Table'[Customer]) calculate(Sum(Table[Total due])), desc)),calculate(Sum(Table[Total due])))

TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448