Look up a result from a measure in another table

[Anonymous]

Hi all, 

I have 2 data tables as follows:

Table 1:

The 'Min Price (Measure)' is a measure as follows. I used that to get the min price grouped by Goods type and Vendor. (Please help correct if I'm wrong) 

Min Price (Measure) = 
CALCULATE(
MIN('Table'[Price]),
FILTER(
ALLSELECTED('Table'),
'Table'[Goods type]=MAX('Table'[Goods type]) &&
'Table'[Vendor] = MAX('Table'[Vendor])))

I then have another Table 2 as below. I need to create another measure that return the min price group by 'Goods Type' and 'Vendor' that I found out through the 'Min price (Measure)' in Table 1. 

The results would look something like this:

I couldn't use LOOKUPVALUE since 'Min Price (Measure)' is a measure, please help suggest other methods.

Also, I need to keep the 'Min price' in Table 1 as a measure and not a column because I would later put a slicer on 'Price' and thus the results of 'Min price' need to be dynamic.

Great thanks!

[parry2k · Accepted solution]

@Anonymous easier is to add a key in both columns by concatenating group type and vendor and set the relationship on it and then it should be work without doing any lookup. 

See attached, tweak it as you see fit.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Hi Parry, many thanks! It works great!