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...
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.