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 moreRelated posts
Linking Queries Run From DAX Studio To Workspace Monitoring And The Capacity Metrics App
A few weeks ago I wrote a blog post about how you can now link event data from Workspace Monitoring to data in the Fabric Capacity Metrics App...
17 hours ago
Power BI MCP Tuner Server and does it reduce capacity requirements – Part 4
This blog post is about using MCP to tune DAX and then using the Automated Load Testing does it reduce capacity. I originally did not plan for...
5 days ago
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...
7 days ago