Loading...

Calculate(), Filter() And DAX Memory Usage

Calculate(), Filter() And DAX Memory Usage
Following on from my last post on the Query Memory Limit in Power BI, in this post I want to look at one of the most common DAX antipatterns and its effect on query memory usage: filtering on a whole table, rather than an individual column, in the filter parameters of the Calculate() function. A … Continue reading Calculate(), Filter() And DAX Memory Usage

Published on:

Learn more
Chris Webb's BI Blog Chris Webb's BI Blog
Chris Webb's BI Blog Chris Webb's BI Blog

A blog about Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query, M, Power Map and Excel for BI

Share post:

Related posts

How to Set Up Agentic Semantic Model Development for Power BI Using GitHub Copilot on Windows

I was inspired and in awe after watching the video that Rui Romano posted in LinkedIn where Rui shared a video on how he used Agentic model de...

6 hours ago

Agentic AI in Power BI and Fabric, Part 2: Getting Started with VS Code, GitHub Copilot, and Safe MCP Setup

A Personal Note Before We Continue Before I continue this series, I want to briefly share why it took me so long to publish this second blog. ...

1 day ago

Power BI And Support For Third Party Semantic Models

I’ve been working with Microsoft BI tools for 28 years now and for all that time Microsoft has been consistent in its belief that semantic mod...

2 days ago

Microsoft Viva: Unlocking Deeper Copilot Insights with Enhanced Power BI Filtering

Enable Global and Insights admins to turn on additional attributes as filters in Power BI reports, including reserved attributes and your orga...

2 days ago

What now for Power BI? The question I can’t escape

Everyone keeps asking me the same question: what now for Power BI? With Microsoft Fabric reshaping its identity and AI-generated dashboards ch...

13 days ago

Setting up Power BI Version Control with Azure Dev Ops

In this blog post is a way set up version control for Power BI semantic models (and reports) using the PBIP (Power BI Project) format, Azure D...

14 days ago

Chat with Copilot inside a report on the Power BI mobile app (Preview)

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform”...

15 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy