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 🙂