How to enable cross filter visual behavior in Power BI when using a measure showing Top N and "Other" row? The question came up in a comment to the article sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/
Watch the video to see how we study the case and prepare our answer!
Read more about the "unplugged" format: sqlbi.com/blog/marco/2021/01/09/the-unplugged-video-series-on-sqlbi-youtube-channel/?aff=yt
#unplugged
- Comment review: Answering a question about TOPN cross filtering - Unplugged #16 ( Download)
- Fixing “Top N and others” report when filtering by date - Unplugged #35 ( Download)
- Using CONCATENATEX in DAX ( Download)
- Comment review: Previous Last Date - Unplugged #12 ( Download)
- Dynamic and nested Top N in Power BI ( Download)
- FILTER - DAX Guide ( Download)
- Filter top 3 products with a row for others using DAX in Power BI ( Download)
- Optimizing LASTNONBLANK and LASTNONBLANKVALUE calculations ( Download)
- List out top items with CONCATENATEX+ in DAX for Power BI ( Download)
- Working below a DAX formula’s granularity ( Download)
- SELECTEDVALUE - DAX Guide ( Download)
- Implementing the “Top N and others” pattern using calculation groups in DAX - Unplugged #28 ( Download)
- DIVIDE Performance ( Download)
- Using ALLSELECTED in composite models ( Download)
- The Nuances of Creating Quality Content (with SQLBI) ( Download)
