Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all I wonder if someone can help me.
I have a table of data which I would like to pull out the top 20 rows depending on a measure value.
Any advice would be fantastic
If you're not looking to write any code, then the filter functions might work for you.
Not sure if you have used these before, so:
Select the table, then head over to the Visualizations pane, under the Filters options, I've selected Customer Number and then the filter type of Top N.
You can then select how many you wish to filter, so I've gone with the Top 20
Then I've dropped a measure, GP GBP, into the By Value option.
Hope this helps.
Andy
Hi @sivareddy123 ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sivareddy123 ,
If you want to pull out the 20 rows, we can just ues the following formula to create a calculated table, you can change the part of [Value]+[Value2] to yours, it will calculate for each rows in table.
Table 2 =
TOPN(20,'Table',[Value]+[Value2],DESC)
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sivareddy123 ,
Try following Dax function to create a new table.
TOP20 = TOPN(20,SUMMARIZ(Table, Table[Column]), [Measure])
let me know if it works with your requirement.
Thank You,
Washivale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
76 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |