Filters and data tables

Hi samucaeq

I think you're looking for a separated table. For example, you have three tables with sales and customer by territories (UsaSales, EuropeSales and AsiaSales). Then, you can create a new table only for Customers taken from each table.

Customer = 

DISTINCT
(
	UNION
	(
	    SELECTCOLUMNS(AsiaSales;"CustomerID";AsiaSales[CustomerID]);    
            SELECTCOLUMNS(EuropeSales;"CustomerID";EuropeSales[CustomerID]);
            SELECTCOLUMNS(USASales;"CustomerID";USASales[CustomerID])
	)
) 

NOTE: You need to create the relationonship between the four tables.

Now, you're able to filter the three tables by The Customer one.

I hope this helps

Regards

BILASolution