ALLCROSSFILTERED but only from a select table

[ashamsuzzoha]

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?

[Anonymous]

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

[Anonymous]

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.

[AntrikshSharma]

@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)