Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Category: Filtering

IsAvailableInMDX: not just an Excel setting

IsAvailableInMDX: not just an Excel setting

Posted on November 5, 2026November 5, 2026No Comments on 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.

DAX 1-Column Fusion Pt 2

DAX 1-Column Fusion Pt 2

Posted on June 24, 2020June 24, 20204 Comments on DAX 1-Column Fusion Pt 2

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

DAX KEEPFILTERS

Posted on March 23, 2020March 23, 202010 Comments on DAX KEEPFILTERS

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

Search

Categories

  • Advanced
  • Aggregations
  • Analysis Services
  • Blog
  • Calculation Groups
  • Columns
  • Composite Models
  • Copilot Productivity
  • Data Modelling
  • DAX
  • Direct Lake
  • Direct Query
  • Distinct Count
  • Easy
  • Fabric Notebook
  • Filtering
  • Inventory
  • Medium
  • Monitoring
  • Optimise
  • Performance
  • Power BI
  • Power BI Refresh
  • PowerShell
  • Relationships
  • Semantic-link
  • SSMS
  • Time Intelligence
  • TMSL
  • TOM
  • Uncategorized
  • VS Code

Recent Posts

  • IsAvailableInMDX: not just an Excel setting
  • Use Column Splitting to optimise Power BI semantic models
  • Power BI calculation groups just got faster to compile
  • Optimize Your Power BI Model: Use COUNTROWS for Distinct Counts
  • Why the RLS bitmap default just went up 4x
Phil Seamark on DAX

Back to top
Loading Comments...