22-25 April 2026 
Using ALLEXCEPT or ALL/VALUES in DAX?
2022TL; DR
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.
Session Details
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.