Measure to sum a column based on other tables column

[paulomartins]

Hello guys, it's my first post here and I'm very glad to be part of this forum.

Recently I'm trying to deal with a logical sum in DAX and to be honest I not dealing with it really well...

My problem is:

I have 3 tables:

I want to sum the MB52[Quantity] based on Current and Old Keys, reaching this result:

Identifying [Current Key] and suming the quantity of the [Old. Key] with owns [Current Key] quantity.

I tried this code but with no sucess 😞

[Sum. Quantity] =
IF
(

'KEYS'[Old. Key] <> "";

CALCULATE(SUM(MB52[Quantity]) ; MAX(MB52[Key]) = MAX('KEYS'[Old. Key])) + CALCULATE(SUM(MB52[Quantity]) ; MAX(MB52[Key]) = MAX('KEYS'[Current Key]));

SUM(MB52[Quantity])

)

I apreciate a lot your help and thanks anyway 🙂

[paulomartins]

It's not the expected way I was thinking to reach it, but it worked like a charm hahahaha

Thanks so much! 

[vapid128 · Accepted solution]

in MB52 table

add colnum

current key

var _newKey=lookupvalue(keys[current key],keys[old key],MB52[KEY])

return

if(_newKey = blank(), MB52[KEY],_newKey)

then make relationhip MB52[current key] and product[current key]