topic Re: ALLCROSSFILTERED but only from a select table in DAX Commands and Tips

ALLCROSSFILTERED but only from a select table

ashamsuzzoha — Wed, 23 Sep 2020 17:31:57 GMT

I have a few calculated measures on a table with relationships with several tables. I want those measures to ignore crossfiltering from one of those tables, but not the others. ALLCROSSFILTERED() seems to remove crossfiltering from ALL related tables. Is there a way to only apply that to select tables? Something that combines the functionalities of ALLCROSSFILTERED and ALLEXCEPT?

Re: ALLCROSSFILTERED but only from a select table

AntrikshSharma — Wed, 23 Sep 2020 18:02:03 GMT

ashamsuzzoha If you use fact table inside ALL family functions then the filters from all the tables related with many to 1 relationships will also be removed, because of table expansion.

use CALCULATE ([Measeure], ALLEXCEPT(Fact, Dimension1, DimensionN)

Re: ALLCROSSFILTERED but only from a select table

Anonymous — Thu, 24 Sep 2020 09:14:55 GMT

If something seems to be almost impossible to do, then it might be a strong indication that the model is not correct (in terms of structure and Best Practices). But to be able to tell what could be wrong with yours... there's not enough information.

Re: ALLCROSSFILTERED but only from a select table

Anonymous — Thu, 24 Sep 2020 09:16:31 GMT

By the way, why do you have to use ALLCROSSFILTERED? Why is it not enough to use ALLEXCEPT( FactTable, TheOneTableYouWantToKeepFiltersOn)?