Forum Discussion
ALLEXCEPT filtering
I can’t follow the documentation ALLEXCEPT function (DAX) - DAX | Microsoft Docs
It says that “Removes all context filters in the table except filters that are applied to the specified columns…”
The below is the code for the column Week Ending Date:
If as the documentation say, I remove all context filter (which there aren’t any, since I’m in SSAS)… then it should just get the minimum Date, why is getting the minimum Date Grouped By Week????
1 Reply
The CALCULATE function performs a context transition. So the row context is now the filter context.
The ALLEXCEPT function then clears the filter context from all columns except Year Week. So your MIN(Date) is is getting the minimum for the Year Week.
