Create new table filtered

[Anonymous]

Hi!

I am having troubles create a new filtered table, using column filters from other tables.

Example:

This is the original table, I should get a filtered table from this

Name  Product  Amount

Nick         A           1000

James      B              500

Jhon        C              200

And i have another table with the products i have exclude from the original table

Product

A

C

Result Table

Name Product Amount

James      B              500

This is an example, in the original table there are more than 100000 rows, and in the exclusion table more than 1000 products

Thank you!!

[Singaravelu_R · Accepted solution]

Related two tables with Product,

and add the calculated column 

Product Result = if(ISBLANK( RELATED('Prodcut Master'[Product])),'Product'[Product])

and in the result apply visual level or page level filter to only values

[amitchandak]

@Anonymous , Try a measure like

new measure =
var _tab = except(allselected(Table[product1]), AllSelected(Table2[product]))
return
calculate(sum(Table[Amount]), filter(Table, Table[product1] in _tab))