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

Sharing Power BI Reports with External Users – Part 3: Sensitivity Labels, Encryption, and Secure Sharing

In Part two of this series, we walked through how to configure your Microsoft Fabric environment to securely share Power BI reports with ...

2 days ago

Grouping And Filtering In Power BI Copilot AI Instructions

Continuing my series on Power BI Copilot AI Instructions (see also my previous post which is the only other one so far), in this post I’...

4 days ago

Important Update: Token Protection Policy for Power Query in Excel

Important Update: Token Protection Policy for Power Query in Excel may block data import scenarios requiring Azure Active Directory authentica...

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