Compare 2 columns and get same items with total

[YerlaSDU]

Hi Folks,

I have a 2 columns from 2 different tables and need to get same items from both and sum of them

As filter, I need to add conditions, where code are same, but CodeName is little different

How can I realize it?

[chilichill]

Hi,
are the first 4 letters unique for each Code Name and identical in both tables? And what does the connection between the tables look like?

[YerlaSDU]

@chilichill 

Code  4 letters is same for both, but codename may be different for the same Code. Connection is Many to One

[chilichill]

Maybe try something like:

Measure = 
VAR CodeTab1 = LEFT(MAX(Table1[Code Name]), 4)
VAR CodeTab2 = LEFT(MAX(Table2[Code Name]), 4)
RETURN
if(CodeTab1 = CodeTab2, SUM(Table1[Value]) + SUM(Table2[Value]), BLANK())

[YerlaSDU]

it always shows blank