Forum Discussion
Top N Filter doesn't work (with examples)
Anonymous
See if this works for you (I wasn't sure what calculation you wanted to see in the visual "TopN sobre Income Total"). I've changed the TopN range to 1 - 4 (assuming the rank refers to "Shops") since there are only 4 possible in the sample data.
The data is showing the values for the TopN Shops overall (ie. not ranked for each category in the visuals)
That is exactly what I need, thank you very much, I do not know how to thank your help.
I only have one problem with the data table, since I had to create another measure to order the shops / managers by AuM desc. The calculation of the total of the table does take into account the filtered Top N, but it shows all the Manager / shops of my table and I just want it to show me:
-If I choose 5: the first 5 managers
-If I choose 10: the top ten
So i created a new measure for tank ONLY for the table:
I had to create this new measure because the measure that you have used returns only the number 1 for all shops / managers as seen below: