Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
eltonsenne
Regular Visitor

Measure with fields from two different tables

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

1 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

View solution in original post

3 REPLIES 3
Piet
Frequent Visitor

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

BR

Piet

 

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
Regular Visitor

Hello all,

 

I have already found a solution!

Thanks anway,

 

Elton Senne

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.