EXCEPT - DAX Guide

thank you

Thank you 👍

Is there a reason you would use Except rather than Filter?

There is something incredible about EXCEPT function which may pass unnoticed. It's got an implicit TREATAS function. This works: EXCEPT( VALUES( 'Date'[DayOfWeek]), SmallTable) ), as long as the SmallTable is a single column table with WHATEVER column name!