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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ADP007
Helper IV
Helper IV

Dynamic Top N

Hi all,

 

I have seen several examples with a dynamic top N but I just can't seem to get it working in my report.

Could someone have a look at my example mScore_topN.pbix at the following link ? mScore 

 

Many thanks

David

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

change your TopN measure to 

 

TopN = if([RANK] <= SELECTEDVALUE('Top N'[Top N]),1,0)

 

and then filter your visual by TopN = 1 

 

lbendlin_0-1603418599195.png

 

View solution in original post

5 REPLIES 5
lbendlin
Super User
Super User

change your TopN measure to 

 

TopN = if([RANK] <= SELECTEDVALUE('Top N'[Top N]),1,0)

 

and then filter your visual by TopN = 1 

 

lbendlin_0-1603418599195.png

 

Hi @lbendlin 

 

This is great many thanks.

I'm not very good with DAX. Any idea how I could also add a Bottom N filter ?

 

Thanks

David

Run a MAXX over the RANKX and then subtract the rank from the result. That makes the BottomN behave like the TopN.

 

Watch out for performance issues with large lists.

Thanks @lbendlin 

 

I'll keep that in mind. For the moment I have duplicated the table and added a top n and bootom n. This way they can compare the top and the bottom at a glance.

 

Thanks for your reply

@ADP007 ,

 

Use what if analysis with incremant of 1 for N filter.

 

Regards,

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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