Forum Discussion
Dynamic TopN filter for multiple columns
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
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
1 Reply
- amitchandakSuper User
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