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
Ranking
The ability to rank things is a very common requirement Finding the best customers computing the ranking position of products or detecting the countries with the best sales volumes are among the questions most frequently asked by management Ranking can… 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