Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

ALLEXCEPT()

Hi Everyone,

I am Rohan, i have been using power bi for quite a long now and i found that ALLEXCEPT() is very helpful when you want to remove 

all context filters in the table except filters that have been applied to the specified columns Syntax - ALLEXCEPT(,[,[,…]]) table- The table over which all context filters are removed, except filters on those columns that are specified in subsequent arguments column- The column for which context filters must be preserved The first argument to the ALLEXCEPT function must be a reference to a table; all subsequent arguments must be references to columns. We cannot use table expressions or column expressions with the ALLEXCEPT function.

Do let me know for any doubts 🙂

hI i

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Well... apart from the fact that it's not true that only references to columns must be placed in the subsequent arguments. You can also place entire tables (with no refs to cols) in there as long as they are part of the expanded table that has been placed as the first argument.