Remove filter using ALL/REMOVEFILTERS from related tables: How exactly?

[Anonymous]

Hi folks,

I am having a seemingly trival problem. I have the following very simple star schema:

There are a 1-* relationship between the [Product] columns from the dimension tables to the fact table.

Now I would like to create a measure that counts the rows in the SalesStatistics table but ignores certain visual and slicer filters:

• suppliers[Supplier] should be ignored
• SalesStatistics[SalesDate] should be ignored
• warehouses[location] should not be ignored

Obviously,

Orderlines = 
	CALCULATE(
		COUNTROWS(SalesStatistics),
		ALL(SalesStatistics[SalesDate],suppliers[Supplier])
	)

does not work because "All column arguments of the ALL/ALLNOBLANKROW/ALLSELECTED/REMOVEFILTERS function must be from the same table."

What am I missing here? The columns should all be in the expanded table of SalesStatistics so why is this not trivial?

Kind regards, aabtra

[johnt75]

You have to remove the filters from different tables in separate steps. try

Orderlines =
CALCULATE (
    COUNTROWS ( SalesStatistics ),
    REMOVEFILTERS ( SalesStatistics[SalesDate] ),
    REMOVEFILTERS ( suppliers[Supplier] )
)

[Anonymous]

Did you try that? I am getting the exact same error.