filter Table1 based on table2 values

[NaniG]

Hi 

I have two tables, one is 12milion records and second table is 100 rows of records 

i want to filter first record with second record 

filter need to show only that contain second table column1 values only

i have found one code in google that showing only except data but i want opposite of except . 

Can you please help me with only contain data to filter 

here is i foung except code : 

CALCULATETABLE(ZKB_MATERIAL,EXCEPT(VALUES(ZKB_MATERIAL[MATERIAL]),VALUES('acrylic sheets'[Column1])))

[AlB · Accepted solution]

Hi @NaniG 

Your explanation is not very clear but I surmise you are looking for INTERSECT instead of EXCEPT. Try this:

CALCULATETABLE (
    ZKB_MATERIAL,
    INTERSECT (
        VALUES ( ZKB_MATERIAL[MATERIAL] ),
        VALUES ( 'acrylic sheets'[Column1] )
    )
)

 If it does not work, please show a sample of your relevant tables and the expected result

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.