Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi,
Please find attached the PBI file.
Hope this helps.
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
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
Customer 1 total 100
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
I am not clear at all about this requirement.
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 🙂
Hi,
Share the download link of the PBI file.
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |