Forum Discussion
Use two TOP N Filters
I am close on getting this table to work, but since I can only use one Top N Filter type, how can I use a measure to only show 5 Frequencies for Bronx, Tampa and LA. I have a measure to count and then check the sum for each and keep the top of teh tied numbers only
3 Replies
bdehning , Just like rank in this video switch TOPN using isinscope
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
TOPN: https://youtu.be/QIVEFp-QiOk
or refer: https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
Hi,
Share data in a format that can be pasted in an MS Excel file and also show the expected result.
I can do that, but for the Bronz, for example, since I want Top 5 Reporting Location City by Count Value and Top 5 Cause Grouping by first Count of Value and then Sum if tied.
Results should be
Bronx - 72
STF - 23
Cut, Puncture -15
Struckby - 10
Then 2 of the 3 that show as count of 8 by using the sum as the next filter and keeping the top 2 of the 3.
