Forum Discussion
Top N Filter Issues
There seems to be a problem in the filter behavior "TOP N" when the report already has other filters. For example, I want to show the 10 players with the best performance, but had a filter for m...
It is all about the filter context. One needs to build a Top N measure, rather than rely on the visual filter - and then that measure will work within the visual filter context.
I recommend a YouTube video by Sam McKay - look for Enterprise DNA N. Zealand:
Video: Create Dynamic Visuals based on Ranking
Context sensitive ranking - this example is about customers and profit but should be applicable in your case:
Customer Rank = RANKX( ALL ( Customer ), [Total Profits], , DESC )
- - you need the ALL otherwise rank will always be #1, since rankX is an iterator
Then make measure
Top 10 = IF ( [Customer Rank] <= 10, [Total Profits], BLANK () )