New table from a another table filtered by one column from a another table

[jagpedroza]

Hi I will try to explain my case.


I have table [A] with columns [supplier] [services] [price] [comision] (the supplier is repeated because offer many services) and i have 6 tables with a column also with [supplier] (not repeated the supplier) i want to create a diferent table ( 6 more) filtering the a table with only the few supplier that I have on the list

[v-jiascu-msft · Accepted solution]

Hi @jagpedroza,

1. Where is the list of the supplier that you mentioned in "I have on the list"?

2. Are they data tables or the Table visuals?

3. Please check out a demo in the attachment.

Table 7 =
FILTER ( A, 'A'[supplier] IN VALUES ( List[Column1] ) )

Best Regards,
Dale

[jagpedroza]

 Hi @v-jiascu-msft it worked flawless, thanks a lot