This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
I have the data for region wise and the period wise ecomm data i want top 5 local names for each region based on the fill rate we have in period wise . i have tried below is screen shot but i need top 5 dsd local names
i need the top 5 as same as below screen shot can you please give me the solution i have tried the dax function also its not working
Solved! Go to Solution.
Hi @Anonymous
Try like below.
Thanks
Hari
Hi @Anonymous ,
You can also refer to this blog: Showing the top 5 products and Other row - SQLBI.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Try like below.
Thanks
Hari
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 27 | |
| 26 | |
| 25 | |
| 21 | |
| 14 |
| User | Count |
|---|---|
| 52 | |
| 46 | |
| 23 | |
| 18 | |
| 18 |