Calculate a Measure between 2 tables

[John-Koz]

Hi,

Trying to create a calculated measure between 2 tables.  One has many SKUs referenced and the other is the master:

New to PowerBI.  Trying to Multiply Qty Per Case 2018 by ACT 2018 JAN (Last Column on the right).  Thanks so much,

[ricardocamargos]

Hi @John-Koz,

If your model has relationship, you can use the RELATED function:

https://msdn.microsoft.com/en-us/library/ee634202.aspx

Also you might wanna calculate something before aggregation, u can do it using the SUMX, COUNTX... functions...

Ricardo

[John-Koz · Accepted solution]

Thanks,

This is what I came up with:

QtyUsedJan = 'SKU Material List'[Qty per Case 2018] * RELATED('SKU Master Production'[ACT 2018 JAN])

It worked