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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.