Forum Discussion

samucaeq's avatar
samucaeq
New Member
8 years ago
Solved

Filters and data tables

I have three data tables with some common columns, mainly descriptive fields. The other columns have fields with numeric values. Each table contains data of a particular parameter of a unit. I did...
  • BILASolution's avatar
    BILASolution
    8 years ago

    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

BILASolution's avatar
BILASolution
Solution Specialist
8 years ago

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