Average of a product based on category

[BaronSdG]

Hi all,

I want to create a column with a product between the values of two columns (#Trips * BDG Forex) from a table B. The grouping category is the column 'Shipping' from table A. Such product must be then summed to have the total per Shipment.

Then, I need to do an average of the total per shipment to obtain the country average

Below the table I am using to show some data.  

Can you please help me?

[V-pazhen-msft]

@BaronSdG 

Please share 2 tables, not a table visual, we must know how are the 2 tables are related by which column.

Paul Zheng _ Community Support Team

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[BaronSdG]

Here are some data samples, but apart from that let me know if I need to further clarify something. Remember that the first columns is ina  different table then the other 2

Shipment	DG Forex	#Trips
53258955	100	1
53258955	200	2
532710625	300	3