ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS
Marco Russo & Alberto FerrariDAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions. Read more
Introducing user-aware calculated columns in Power BI
This article describes the new Expression Context property of calculated columns in Power BI, explaining how user-aware calculated columns work, why they are not materialized, and how to use them as virtual calculated columns for localization and custom security scenarios. Read more
Jul 21-23 - Amsterdam
Jun 10-12 - Zürich
Nov 9-11 - Atlanta
Video Training
Introducing DAX Video CourseFree
Filtering measures through slicers
A 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
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
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