Forum Discussion
Help needed regarding Nested Filter in Power BI
I am looking for help with nested filtering in Power BI and below is my situation, I have a country column and Device name column in my dataset. I want to first filter out the countries having gr...
Hi AbhishekAejae ,
I create a table as you mentioned.
I think you can create two new tables.
Table 2 = SUMMARIZE('Table','Table'[Country],"Count Device",COUNTROWS('Table'))
Table 3 = TOPN(5,'Table 2','Table 2'[Count Device],DESC)
Then you can create another table and it will give you what you want.
Table 4 = TOPN(3,'Table 3','Table 3'[Count Device],ASC)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous - Unfortunately, the given solution is not working for me. Thank you for your help!
Hi AbhishekAejae ,
Can you please give me specifically is example data? After all, I don't know what the specific data is in the language you have elaborated.
Best Regards
Yilong Zhou
