Forum Discussion
Simple ALLEXCEPT
Hi,
Thank you all for your replies but the real reason why it doesn't work is as follow:
ALLEXCEPT behaves as described in the documentation only when it's used as a filter argument in CALCULATE, otherwise it would return the table of its first argument without/except the columns in the subsequent arguments.
A way to prove this, is look at the ALL function that behaves the same way: A single ALL returns all the table of its argument, and the ALL as a filter argument in CALCULATE removes the filters on all the columns of the table.
Two completely different behaviors depending on the context of the function.
…DAX and his ambiguities.
Hi,
Thank you all for your replies but the real reason why it doesn't work is as follow:
ALLEXCEPT behaves as described in the documentation only when it's used as a filter argument in CALCULATE, otherwise it would return the table of its first argument without/except the columns in the subsequent arguments.
A way to prove this, is look at the ALL function that behaves the same way: A single ALL returns all the table of its argument, and the ALL as a filter argument in CALCULATE removes the filters on all the columns of the table.
Two completely different behaviors depending on the context of the function.
…DAX and his ambiguities.