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...
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.

     

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.