Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
pls try to create two measures
sales2 = sum('Table'[sales])
rank = rankx(all('Table'),[sales2],,DESC)
then add rank in the filter and select rank which is equals to or less than 10
Proud to be a Super User!
@ryan_mayu Thank you for appreciating others in the loop too. Great community support. Kudos guys
Or without measures, easily you can achieve.
Ue filter pane and do as show in the picture. Ranking is done.
Kindly mark as solution
pls try to create two measures
sales2 = sum('Table'[sales])
rank = rankx(all('Table'),[sales2],,DESC)
then add rank in the filter and select rank which is equals to or less than 10
Proud to be a Super User!
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.
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.
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |