Calculate(), DAX Fusion And Filters On 0 In Power BI
Here’s a fun DAX performance tip that I found this week. Do you have measures that use Calculate() with a filter on a numeric column? Is one of the filters on the value 0? If so then this may affect you. As always, a simple example is the best way of explaining the problem and … Continue reading Calculate(), DAX Fusion And Filters On 0 In Power BI
Published on:
Learn moreRelated posts
Fabric Fridays #118 - DAX Columns vs NO DAX Columns
17 hours 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...
3 days ago
Mastering DAX 3rd Edition Unplugged
4 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...
4 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”...
5 days ago
Power BI TMDL Security Roles Done Right
10 days ago