Need relationshp btw 2 tables Table-A Table-B which are not having common column for Merging 2 table

[Anonymous]

TABLE A

name	ID	result	method
A	123	2	cod
A	125	30	mod
B	1246	43	cod
C	138	51	mod
C	139	23	eod
D	527	22	cod
D	530	3	mod
D	529	40.3	eod
C	140	2.82	cod

TABLE B

A ID	B ID	C ID	D ID
122	1246	138	527
123	1241	139	530
125	1200	140	529
129	1234	142	520

result:

[PijushRoy]

Hi @Anonymous 

Please break the lookup table
Turn off Intraction between slicer
PBIX file - https://drive.google.com/file/d/17bzyqn66L_Tsc6a9ND7nR8fix7dmImuj/view?usp=drive_link 

Thanks

[PijushRoy]

Hi @Anonymous 

Unpivot the Table B, Copy and paste the code in Advance editor

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Tcu7DcAgDEXRVZBrCv9I8CyI/dfAfklBcy356K1Foko9608dm9mhb7bR7sX2sYCj2PjiAeZ6iTPWcXGAzcEK/tf7AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"A ID" = _t, #"B ID" = _t, #"C ID" = _t, #"D ID" = _t, #" " = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"A ID", Int64.Type}, {"B ID", Int64.Type}, {"C ID", Int64.Type}, {"D ID", Int64.Type}, {" ", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{" "}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Removed Columns", {}, "Attribute", "Value")
in
    #"Unpivoted Columns"

Create Relation

Create visual

PBIX File link - https://drive.google.com/file/d/17bzyqn66L_Tsc6a9ND7nR8fix7dmImuj/view?usp=sharing 

If solve, mark as RESOLVED. Appreaited your Like/Kudis

[Anonymous]

we need to add A ID ,B ID ,C ID ,D ID as separate slicers.

reference source  Re: Releationship - Microsoft Fabric Community