Filter line item based on text value in another table

[PBrainNWH]

I have a value entry table (Value Entry) with a list of line items from sales orders (the below is one sales order):

I need a specific Qty_per Unit of Measure from another table (Item UoM) based on the Item No. and Variant:

The 296.13 is the sum total of all Qty_per Unit of Measure values for that Item No. (FD-0001) in the Item UoM table. I only want the value that corresponds to the specific variant (ex. first line on Value Entry is 40/3/2OZ). So on Value Entry table for the Item No. FD-0001, instead of 296.13, I want 8.

Is this possible? If so, I need help with the measure syntax.

[PBrainNWH · Accepted solution]

CALCULATE(AVERAGE('Item Unit of Measure'[Qty_ per Unit of Measure]),

FILTER('Item Unit of Measure','Item Unit of Measure'[Item No_] = 'Value Entry'[Item No_] && 'Item Unit of Measure'[Code] = 'Value Entry'[Variant Code]))