Forum Discussion
Top N Filter doesn't work (with examples)
Anonymous
Can you pease share the PBIX file itself? (through Onedrive, Dropbox, Google Drive..)
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: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!)
Anonymous
Thanks for the file.
A couple of questions:
1) So when you want to flter by TopN managers, which field determines "Manager"? Is it "Shop"?
2) When you wish to filter by the TopN, is the TopN for the whole dataset (so when you show the results by for example "Asset Class", the TopN refers to the overall performance and not the TopN within "Asset Class") , or is each visual to represent the TopN for the category shown in the visual? - see my example in my previous post.
The top N refers to the managers with the most assets under management. That is to say:
-If I filter by Top 5 I want the entire page to be filtered with the data of the 5 managers with the most assets under management, I do not want data from other managers to appear that are not that top 5
-If I filter by Top 10 I want the entire page to be filtered with the data of the 10 managers with the most assets under management, I do not want data to appear from other managers that are not that top 10
In the case of the graph: AuM by Asset Class I want the filter on selector 5 or 10 or 30 .. that graph shows the AuM of those selected managers filtered by Asset Class.
In summary, I want both the top 3 letters on the right, as well as the table, and the different graphs ONLY to show me the data of the Top N filter managers that I have selected. And that data is the relationship between the AuM column and different columns with other categoriesI have created a proxy eliminating the real data and eliminating columns to be able to share the powerBI and the equivalences are the following:
Shops = Managers
Seller = Fund
Sales = Aum
Thank you very much for the great help