Filtering Archives - Phil Seamark on DAX

DAX 1-Column Fusion Pt 2

June 24, 2020June 24, 20204 Comments

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here it is. This article is also a fun reminder/refresher on how iterator functions work in Power BI. … Continue reading DAX 1-Column Fusion Pt 2

DAX KEEPFILTERS

March 23, 2020March 23, 202010 Comments

If you ever spend time looking at DAX generated by the Power BI Desktop Performance Analyser, you may notice a function called KEEPFILTERS appear from time to time. It’s not a function I find myself using often, so I thought I’d do a bit of digging to find out what it does and when it … Continue reading DAX KEEPFILTERS