Lookup between two tables

[Anand09]

Hi Everyone,

I have  to lookup rows between two tables. if one row is completely matching with row in other tables have to create a slicer with same else different. Providing sample data below.

ID	NAME
1	XYZ
2	ABC
3	XYZ
4	ABC

ID	NAME
1	XYZ
2	ABC

[v-pagayam-msft]

Hi @Anand09 ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue.

The following steps may help you to create if one row is completely matching with row in another table

• Go to the "Model" view
• Create a relationship between 2 tables with unique column and go back to the "Data" view.
• Select Table1,create a new calculated column. Below query helps you to create a calculated column.
  

  IF (

      RELATED('Table2'[NAME]) = 'Table1'[NAME],

      "same",

      "different"

  )

• Add the new calculated column to the slicer visual, Now select either Same or Different in slicer. Will be able to see the lookup rows between two tables.
• Please find the attached sample file for your reference.
  
  Hope this post helps you. If so, kindly consider accepting it as the solution so that it can assist other members and help them find the answer more quickly.

[Ajithkumar_P_05]

Try this calculated column

Ensure that search value from table 2 should be unique.

[anmolmalviya05]

Hi @Anand09, Please try to create a new calculated column with below formula:

RowMatchStatus =
IF(
COUNTROWS(
FILTER(
Table2,
Table2[ID] = Table1[ID] &&
Table2[NAME] = Table1[NAME]
)
) > 0,
"Same",
"Different"
)