Need to lookup value from another table if they not same give me not matching

[Atinder]

Hello,

I am trying to lookup a valume from another table. In this case I want to Lookup Sales UOM from Item card table into Bin Content  table. If we they are not matching give me " Wrong UOM". 

I am trying to find how many Bins  I have with Wrong Unit of measure beacuse If i only sell them into MASTERCASE. I should not have any PCS on hand in the warehouse. 

Thank you

[ryan_mayu · Accepted solution]

@Atinder 

create relationship between two tables and try to crreate a column

Column = if(RELATED('Table (2)'[Sales UOM])='Table'[UOM],'Table'[UOM],"Wrong UOM")