Tailor-made issues and related tables

[Syndicate_Admin]

Good afternoon, I would like to consult for something very specific but perhaps simpler than it seems.

In summary I have 2 tables:

1. Where sales orders and general sales data are recorded, specificity of the kilos delivered

2. The costs associated with each sales order are recorded, for 1 sales order there can be many associated costs depending on the breakdown one wants to use, in my case generally for each sales order there are 3 costs, ground cost, air cost, and documentary cost (associated with air transport)

Here are my two sample tables:

Table 1:

PV	Kilos	Destination	Date	SMEANA
1	5000	CHINA	44207	2
2	2000	USA	44207	2
3	3000	USA	44208	2
4	2500	CHINA	44208	2
5	8000	PERU	44209	2

Table 2:

PV	TRANSPORT TYPE	TRANSPORT COMPANY	COST TYPE	Cost
1	103	GLA	Transport	800
2	103	GLA	Transport	200
1	104	Latam	Transport	3000
2	104	Qatar	Transport	2500
1	104	ARTURO PEREZ	Documentary	300
2	104	ARTURO PEREZ	Documentary	300
3	103	VASQUEZ	Transport	600
4	103	VASQUEZ	Transport	300
3	104	Qatar	Transport	3000
4	104	Latam	Transport	2500
3	104	ARTURO PEREZ	Documentary	300
4	104	ARTURO PEREZ	Documentary	300
5	103	GLA	Transport	800
5	104	Latam	Transport	6000
5	104	ARTURO PEREZ	Documentary	300

The measure I want in general is to calculate the cost per kilo ($/kg), and that I can use it for the different filters in the cost table, for example, wanting to see by type 103 transport, its rates,

TRANSPORT COMPANY	Sum of COST	kilos2	•/kg
CONTOPSA	800	20500	0,04
GLA	1000	20500	0,05
VASQUEZ	900	20500	0,04
Total general	2700	20500	0,13

I can't understand why for each tranposrte it says that it is 20500 kilos, and therefore mis calculates the rate, it should be for Contopsa only 8000 kilos (since the contopsa transport only carries the PV 5), for Vasquez 5500 kilos since it only carries the PV 3 and 4,

Could you help me understand what I'm doing wrong? I need to create another table to join both?, I'm connecting both tables just by the PV

Thank you very much, my cel is 56981598377, I am available to receive feedback by wsp if you like.

[Anonymous]

Hello @Syndicate_Admin 
You just simply drag the kilos column and make it don't summarize or use the cross filter.

CALCULATE(

SUM(Kilos[Kilos]),

CROSSFILTER(Kilos[PV], Transport[PV], Both)

)