IsAvailableInMDX: not just an Excel setting
Turning off IsAvailableInMDX can save memory, but it can also slow down a DAX query. A real text-filter example explains why this is not simply an Excel setting, and what to check before changing it.
Data modelling and DAX
Turning off IsAvailableInMDX can save memory, but it can also slow down a DAX query. A real text-filter example explains why this is not simply an Excel setting, and what to check before changing it.
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
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