Measure to lookup value from multiple tables

[Dayna]

Hello All,

I have a report with a lot of tables and long dwindling relationships, and I need to get a value from a table which should be searched on by two columns.

I've loaded the table with the results in that I want to lookup on, table: Specification and field is Quantity.

In the Specificationtable, there's a field called Parent which I want to search on from the table Product and the field is Product, and then in the Specification table there's a field called Child which I want to search on from the table Components and the field is Component.

So in the Specification table, I want to filter the Parent and Child columns, and return Quantity.

At the moment the Specification table has been loaded but isn't related to anything in my report. 

Can you advise how I do this, please? I presume using LOOKUPVALUE measure, but not entirely sure how to filter on the multiple columns.

Many thanks for your help!

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...