Analyzing the performance impact of visual calculations
Marco Russo & Alberto FerrariVisual calculations can either improve or degrade the performance of a report. In this article, we outline how we ensure visual calculations have a positive impact on performance. Read more
Dynamic formatting by hierarchy level with ISINSCOPE and ISATLEVEL
This article describes how to apply different formatting rules at each level of a hierarchy (one rule at the year level, another at the quarter level, another at the month level) using ISINSCOPE in a measure or ISATLEVEL in a… Read more
Oct 12-14 - Warsaw
Oct 27-29 - Lugano
Nov 9-11 - Atlanta
Nov 24-26 - London
Video Training
Introducing DAX Video CourseFree
Generative AI guidelines at SQLBI (2026 update)
Marco Russo3 years ago, we wrote our “Generative AI guidelines at SQLBI”. We think it’s time to update them. Over the past 3 years, the world has changed: it is simply no longer possible to avoid using generative AI services for… Read more
Using REMOVEFILTERS in DAX user-defined functions
In this article, we implement a function that removes filter-keep column filters from a calendar, using REMOVEFILTERS as the return value of the function. Read more
DAX Patterns
Cumulative total
The cumulative total pattern allows you to perform calculations such as running totals You can use it to implement warehouse stock and balance sheet calculations using the original transactions instead of using snapshots of data over time For example 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