Filtering measures through slicers
Marco Russo & Alberto FerrariA slicer cannot filter a measure. In this article, we analyze this common request by explaining how to use a slicer to filter a measure, after discussing the real meaning of using a measure with a slicer. Read more
Understanding parameter types in DAX user-defined functions (UDF)
This article describes the parameter types available in DAX user-defined functions, focusing on the specialized reference types MEASUREREF, COLUMNREF, TABLEREF, and CALENDARREF. Read more
Jul 21-23 - Amsterdam
May 27-29 - Baltimore
Jun 10-12 - Zürich
Jun 15-17 - Berlin
Video Training
Introducing DAX Video CourseFree
Using visual calculations to highlight an entire row
Visual calculations can be used efficiently to format visuals. This article presents an interesting technique to highlight a row based solely on the maximum value in the last column. Read more
SQLBI+ updates in April 2026
Marco RussoWe released a new session in SQLBI+: How to navigate the lattice of visual calculations: This video explains how to navigate the lattice of visual calculations in DAX, using COLLAPSEALL and EXPAND to move between levels. A key topic is… Read more
DAX Patterns
New and returning customers
The New and returning customers pattern helps in understanding how many customers in a period are new returning lost or recovered There are several variations to this pattern each with different performance and results depending on the requirements Moreover it… More on DAX Patterns
Microsoft Press
The Definitive Guide to DAX, Third Edition
The Definitive Guide to DAX is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services, and Excel.
Read more