Forum Discussion

NaniG's avatar
NaniG
Frequent Visitor
3 years ago
Solved

filter Table1 based on table2 values

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])))

 

Need Help
  • AlB's avatar
    AlB
    3 years ago

    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.

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    3 years ago

    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.