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 matches > 5. When you apply the "TOP 10" filter, are returned only 3 players, because the filter "TOP N" filters the original data, and not the data already filtered by the "greater than 5 matches."
I believe the expected behavior for my problem should be - the filter "TOP N" respect other filters applied. That is, the TOP N should be the last filter applied, not the first.
Thanks,
Rameshwar
2 Replies
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 () )
