Session

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.

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top