Lookup column for filtered data

[sophtee]

Hello everyone,

I have 2 tables in Power BI.

However when I created 2 reports (from the 2 separate tables), I would like to look up from a list of filtered data and fill in the other table:

Age1 = LOOKUPVALUE('FHL-Tray Data'[Ageflk],'FHL-Tray Data'[Flk#],'podndatabasetable (2)'[Flock1])

Below shows the 2 tables which are both filtered tables. Is there a way to fix this column or can I create a flow to add this data to excel?

[barritown · Accepted solution]

Hi @sophtee,

This piece of code should help you:

In plain text:

Age1 = 
VAR currentFlock = [Flock1]
RETURN MAXX ( FILTER ( T2, [Flk#] = currentFlock ), [Ageflk] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

[v-yaningy-msft · Accepted solution]

Hi, @sophtee 

Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

Measure:

Age1 =

LOOKUPVALUE ( Table2[Agefilk], Table2[Flk#], Table1[Flock1] )

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[barritown · Accepted solution]

Hi @sophtee,

This piece of code should help you:

In plain text:

Age1 = 
VAR currentFlock = [Flock1]
RETURN MAXX ( FILTER ( T2, [Flk#] = currentFlock ), [Ageflk] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian