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!

Reply
DeEviloN
Helper III
Helper III

rankx top 10

I have a large list of organizations of 25k, which makes it difficult due to lack of memory when working in Power Bi, I only need to show the top 10 of them based on sales, and also display the rating

DeEviloN_0-1660294843025.png

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@DeEviloN 

pls try to create two measures

sales2 = sum('Table'[sales])
rank = rankx(all('Table'),[sales2],,DESC)

1.PNG

then add rank in the filter and select rank which is equals to or less than 10

2.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

6 REPLIES 6
saravanan_p
Resolver III
Resolver III

@ryan_mayu Thank you for appreciating others in the loop too. Great community support. Kudos guys

saravanan_p
Resolver III
Resolver III

sl3.png

Or without  measures, easily you can achieve.
Ue filter pane and do as show in the picture. Ranking is done. 
Kindly mark as solution

ryan_mayu
Super User
Super User

@DeEviloN 

pls try to create two measures

sales2 = sum('Table'[sales])
rank = rankx(all('Table'),[sales2],,DESC)

1.PNG

then add rank in the filter and select rank which is equals to or less than 10

2.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




DeEviloN_0-1660297175264.png

tried, but the task freezes due to the large number of organizations

Hi,

25K rows is not a lot of data.  Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@DeEviloN 

if you dont need to display the rank, you can try @saravanan_p 's solution

otherwise, there are some other solutions you can try

e.g. you can try to group by the table to reduce the data amount and try the measure solution I provided.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.