Lugano, TI, CHUsing VALUES in SUMMARIZE
Marco Russo & Alberto FerrariThis 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
Understanding value filter behavior in SUMMARIZECOLUMNS
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
Dec 2-4 - Amsterdam
Nov 12-14 - Chicago
Video Training
Introducing DAX Video CourseFree
Introducing calendar-based time intelligence in DAX
This article introduces the new calendar-based time intelligence functions in DAX, available in preview from the September 2025 release of Power BI. Read more
Introducing user-defined functions in DAX
User-defined functions are a new and exciting feature in DAX. In this article, we outline the key concepts to understand before using them in Power BI projects. Read more
DAX Patterns
Transition matrix
The Transition matrix pattern analyzes changes in an attribute assigned to an entity at regular intervals For example customers might receive a ranking evaluation every month or products might have a rating score measured every week Measuring the changes in… More on DAX Patterns
SQLBI Corp.
Optimizing DAX, Second Edition
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