Forum Discussion

tyeriksen's avatar
tyeriksen
Frequent Visitor
5 years ago

Help with Top N filter

Hi all, I have a visualisation of 200+ athletes, where I want to show top N = 5 for particular calculated measures and sums. 

link to file below.


An example (which happens across many different Measures on the page "Leaderboard Pitchers, or if I include a column by year in the page "Regular Season Batting Records")

When I filter Name by top 5 of the measure, I get nothing. 

If I take top 27, I get my top 5. 

If I take top x, it grows accordingly, but I dont understand the logic.

No other page or report filters which could be causing the problem.

 

Any advice why this happens?

File is here:

https://1drv.ms/u/s!Alr9NCLvEz89vlnZ92vqADFIgQmX?e=9xTsSL

Thanks!

General Comment
Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi tyeriksen ,

    As checked your report file, there are many reports pages. Which report page contains the top 5 of measures? Is the report page named "Leaderboard Batting"? Could you please provide a specific screenshot (including the report page, the name of the measures and the table visuals involved) to illustrate your problem? Thank you.

    Best Regards