Forum Discussion
Top N Filter doesn't work (with examples)
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:
Anonymous
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 shopsCan 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