Using ALLEXCEPT or ALL/VALUES?

In DAX, ALLEXCEPT is a convenient function to remove filters from a table, except for 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.