Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A 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.

Reply
Anonymous
Not applicable

undefined

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

jyothi12_1-1655726434507.png

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

 

jyothi12_0-1655726244477.png

 

1 ACCEPTED SOLUTION
Hariharan_R
Solution Sage
Solution Sage

Hi @Anonymous 

Try like below.

https://community.powerbi.com/t5/Desktop/Variable-Top-N-depending-on-Column-Conditions/m-p/2580579#M...

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @Anonymous ,

 

You can also refer to this blog: Showing the top 5 products and Other row - SQLBI.

 

Icey_0-1656055783391.png

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hariharan_R
Solution Sage
Solution Sage

Hi @Anonymous 

Try like below.

https://community.powerbi.com/t5/Desktop/Variable-Top-N-depending-on-Column-Conditions/m-p/2580579#M...

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.