Forum Discussion
Solved
ALLEXCEPT Confusion
Hi, I have an issue with ALLEXCEPT. I have a factinternetsales (fact) table with relationship to a few dimension tables (calendar, customer, product, promotion). Slicers were added from calendar ...
Ideally you should not filter fact tables. You filter dimension tables, and the data model does the rest of the work for you. If you filter fact tables you risk getting wrong results if that filter interferes with a dimension filter.
ALLEXCEPT is a very blunt instrument (similar to ALL) and should be used sparingly. REMOVEFILTERS is much more gentle.
Ideally you should not filter fact tables. You filter dimension tables, and the data model does the rest of the work for you. If you filter fact tables you risk getting wrong results if that filter interferes with a dimension filter.
ALLEXCEPT is a very blunt instrument (similar to ALL) and should be used sparingly. REMOVEFILTERS is much more gentle.