22-25 April 2026 
Alberto Ferrari
sqlbi.com
Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.
Video unavailable
SQLBits 2022
Using ALLEXCEPT or ALL/VALUES in DAX?
In DAX, ALLEXCEPT is a convenient function to remove filters from a table, except from some columns. Being a CALCULATE modifier, it can lead to unexpected results, if not used properly. In this session we show when to use and when to avoid using it, to obtain sound code that works in any situation.
In DAX, ALLEXCEPT is a convenient function to remove filters from a table, except from some columns. Being a CALCULATE modifier, it can lead to unexpected results, if not used properly. In this session we show when to use and when to avoid using it, to obtain sound code that works in any situation.