Join and add data from tables with multiple data

[RicardoLeivaG]

HI, Groups,

I need your help.

I have a table with the following data:

Fill Rate
Sales Ordes	Qty Invoice
OV1	8
OV2	9
OV3	9

and another table with the following data

Detail Invoide
Sales Ordes	Qty Order	Qty Ship
OV1	8	4
OV1	8	4
OV2	9	3
OV2	9	3
OV2	9	3
OV3	9	6
OV3	9	3

I need to add 1 column to the fill rate table that keeps me the value of the ordered qty of the OV detail table

Result:

Fill Rate
Sales Ordes	Qty Invoice	QTY Order
OV1	8	8
OV2	9	9
OV3	9	9

Thanks

[parry2k]

@RicardoLeivaG I'm sure you have already added a relationship of these to tables, add a measure 

Qty Ordered = MAX ( SalesDetail[Qty Ordered] )

In table visual, use sales order and qty invoice from sales table, and this Qty Ordered measure 

[RicardoLeivaG]

Dear:

I tried his soucion but he doesn't show me the data, it just brings me the highest value in the table. 😞

[v-lid-msft · Accepted solution]

Hi @RicardoLeivaG ,

If the two tables have relation with Sales Orders Column, we can create a calculated column to meet your requirement:

QTY Order = CALCULATE(MAX('Detail Invoide'[Qty Order]),RELATEDTABLE('Detail Invoide'))

If it does not meet you requirements, could you please make a more complex table or explain the logic of how to get the QTY Order column?

Best regards,