Help - Want to determinate the film who are the same in two differents tables

[enBRNanda]

Hello devs,

In my two top 100 below :

If the name is in the two tables (Netflix and IMDB in the column PrimaryTitle), please put it in a new tables (Film who are in the two top 100). I don't want to use Power Query but as a beginner, i don't know if it's possible to do it with DAX or with the different Rapport (as a merge tables charts or idk).

Please help me to do it !

Thank you in advance for your help,

EnBRNanda.

[Anonymous · Accepted solution]

Hi @enBRNanda ,

You can create a calculated table as below to get it, please find the details in the attachment.

Table = 
UNION (
    SELECTCOLUMNS (
        FILTER ( 'Table1', 'Table1'[Personnalise] IN { "NETFLIX", "IMDB" } ),
        "primaryTitle", 'Table1'[primaryTitle]
    ),
    SELECTCOLUMNS (
        FILTER ( 'Table2', 'Table2'[Personnalise] IN { "NETFLIX", "IMDB" } ),
        "primaryTitle", 'Table2'[primaryTitle]
    )
)

Best Regards

[Whitewater100]

Hi:

Here is a couple of workarounds on the attached file. I hope this helps..

https://drive.google.com/file/d/1lHhLDuUPKMDPgtGfBHsq_PnucshUSLRn/view?usp=sharing 

The Match Table and Match table are the ones to look at. INTERSECT would usually work but our column names are a bit different, so it did not.