Help needed regarding Nested Filter in Power BI

based on my latest knowledge you cannot use included-slicer in power bi. you should download visuals like chiclet slicer and .... because you need to add some measures to the filter pane which can filter based on your preference. the measures you should write is...
measure :=
var tbl1 = filter(summarize(mytable,country,"device_count", count(device)),device_count >10)
var tbl2= rankx(tbl1,device_count,,asc)
return
if( filter(tbl2,device_count<20),1,0)

add this measure to filter pane and set it to filter for 1!

If this post helps, then i would appreciate a thumbs up 👍 and mark it as the solution ✅to help the other members find it more quickly. 

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.