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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Syndicate_Admin
Administrator
Administrator

Top N filter help

Hello! I am trying to put together a Top 5 filter that should filter me a series of tasks, depending on its date of completion showing me only the 5 oldest.
I tried to do it directly using the Top N filter from the filters tab of the visual but I do not get the result I am looking for, I think because there are values that are repeated (which makes it show me much more than 5 values).
I have also tried to solve it by means of measures, for example with RANKX, but I did not reach the desired result either, what would be the best way to do it? What I need is to show if or if only 5 results, those of older date.
Thank you!

1 REPLY 1
amitchandak
Super User
Super User

@Syndicate_Admin , Make sure you are using values

example

calculate([Net Sales PY], TOPN(5, allselected('Address'[Country ISO]), [Net Sales PY],desc), values('Address'[Country ISO]))

 

TOPN: https://youtu.be/QIVEFp-QiOk

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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