Dynamic TopN filter for multiple columns

[MaliniBaktha]

hi, 

I have 7 types of channel a customer comes in and 300 types of visit they make in every channel. I want to use a dynamic filter that uses the counts of visit types by top3 visit types in each channel. Is there a way to do it. I have tried a dax but it works for only one visit type . instead of all the 4 columns 

[amitchandak · Accepted solution]

@MaliniBaktha , Based on what I got, you have switch TOPN using isinscope

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ