Sat.Jul 06, 2024

article thumbnail

DAX Measures That Never Return Blank

Chris Webb BI

Following on from my earlier post on the Query Memory Limit in Power BI , and as companion to last week’s post on how a DAX antipattern using Calculate() and Filter() can lead to excessive memory consumption by queries (and therefore lead to you hitting the Query Memory Limit), in this post I want to look at the effects of another DAX antipattern on performance and memory usage: measures that can never return a blank value.

Matrix 271