how to create measure for 2 tables with already relationship

[Anonymous]

hi Experts

please help how to validate the the DELIVERY UNIT?. how to create measure to identify the delivery unit is correct or not

Table name : PRODUCT

PRODUCT	DELIVERY UNIT	PACK CODE
100011004	4	004
100011004	0.05	004
100011322	15	322
100011366	25	366

Table name: RefTABLE

PACK CODE	PACK SIZE	PACK DESCRIPTION
004	0.05	0.05KG BAG
322	10	10KG ALU BAG
366	25	25KG BIG BAG

[v-stephen-msft]

Hi @Anonymous ,

What's your logic? Please provide the expected results.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.