Forum Discussion
Top N Filter doesn't work (with examples)
Community ChampionAnonymous
Sorry, I'm not sure what you mean in your last post (or who you are referring to...!)
If you are referring to the solution I suggested, you can limit the list of Shops/managers in the table visual by using a measure such as:
Selected RankX = IF([RankX Shops Overall] <=[Selected N], [RankX Shops Overall])
To give you this:
Ps.
1) The example you posted to solve this seems wrong, since you are filtering by Top 10 and you are getting the 11 top managers (if not more! Which means something is wrong with the [Overall Value] calculation too BTW - please check the Dimension Tables in the sample PBIX file I attached and how they are used in both the measures AND visuals AND the actual model relationships).
To solve this, if you want to use your measure, try changing the [value] expression in the new rank measure with [Overall value]
2) If you want to get rid of the Rank value in the "Total" row in the table, use the ISINSCOPE function (sorry, I'm not in front of my pc so I cannot be more precise. if you need help with this, just let us know!)
Yes, sorry for my english it's not good that i would.
The problem is that if i click 5 on this filter:
I only want to see in the table, the top 5 shops/managers with more Aum. If i click 10, i only want to see in the table top 10 managers/shops with more Aum
And the result that this table shows is:
There are all shops/managers in the table (210 more or less). But, Overall value IS CORRECT because that 39.879.306... its the sum of the 5 top shops, but the table shows all shops
- PaulDBrown
Can you post the measures you have used to calculate the [Overall Value]? In the example I provided, the rows beyond the selected TopN are blank, so there os something going on in your measures