Measure with fields from two different tables

[eltonsenne]

Hello All

I'm a really beginner user so . . . .

I have two tables as bellow:

Products [Prod_ID;Description;Prod_Weight]

Orders [Order_ID;Prod_Id;Quantity Manufacture]

I need to calculate the Total Weight in the Orders Table:

TW = Prod_Weight * Quantity Manufacture

Once I start to create a measure I'm not able to refer to field Quantity Manufacture in Products Table.

Where is my mistake?

Thank you in advance,

Elton Senne

[Piet]

Hi Elton, can you show me the solution, i have the same task.

BR

Piet

[eltonsenne · Accepted solution]

Hi @Piet I took some time to find the solution, sorry for that.

Here we go:

https://community.powerbi.com/t5/Desktop/Calculate-Total-Sales-Value-while-taking-the-prices-product...

Have fun!

Elton Senne

[eltonsenne]

Hello all,

I have already found a solution!

Thanks anway,

Elton Senne