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

Calling DAX UDFs From Power BI Copilot

Can you call a DAX UDF from Power BI Copilot? I was asked this question by Jake Duddy during the livestream on Power BI Copilot I did with Rei...

20 hours ago

Power BI semantic models as accelerators for AI-enabled consumption

As data volumes grow exponentially, Power BI customers demand AI-driven analytical solutions that scale to petabytes, are secure, governed, an...

5 days ago

Monitoring The DAX Queries Generated When The Power BI Copilot Index Is Built

In my last post I talked about the text index that Power BI Copilot builds to help it answer data questions. You might be wondering if you can...

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