Help needed regarding Nested Filter in Power BI

[AbhishekAejae]

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 greater than 10 devices count and among these filtered countries, I want to then filter out bottom 20 countries which should be dynamic and should be affected with the slicers placed.

[Anonymous]

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.

[AbhishekAejae]

Hi @Anonymous  - Unfortunately, the given solution is not working for me. Thank you for your help!

[Anonymous]

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

[Selva-Salimi]

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.