This article explains the distinction between model-dependent and model-independent DAX user-defined functions, highlighting how dependencies impact portability and maintenance, and provides guidance on avoiding hidden dependencies and adopting proper naming conventions. Read more
This article outlines the process of creating a measure to identify the top 10 products by sales each year. Read more
This article describes when to use VALUES in a table grouped by SUMMARIZE, then goes on to explain why you cannot however use VALUES with SUMMARIZECOLUMNS. Read more
Value filter behavior is a setting in Power BI semantic models that controls how filters are combined in SUMMARIZECOLUMNS. This article explains how it works and suggests its best configuration. Read more
This pattern is a useful technique to compare the value of a measure in different time periods For example we can compare the sales of the last month against a user-defined period The two time periods might have a different… More on DAX Patterns
Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. Read more
Amsterdam, NL
Marco Russo & Alberto Ferrari
Dec 8-10 - Austin