cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Measure to sum a column based on other tables column

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 🙂

1 ACCEPTED SOLUTION
Solution Specialist

in MB52 table

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]

2 REPLIES 2
Frequent Visitor

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

Thanks so much!

Solution Specialist

in MB52 table

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]