lookupvalue filtering 2 columns

[bharka]

Hi,

sorry if this problem was already solved here, i was trying to find it but none of the solutions i found helped (but i'm a beginner).

I have two tables: 

i need to get the passing coefficients from the second table to the first one as a new column. Both group 1 and group 2 can be duplicate but the combinations of the groups are unique. The coefficients do not have to be unique. obviously i can't use LOOKUPVALUE and i'm kind of stuck here. Can anyone help me please?

[Zubair_Muhammad · Accepted solution]

@bharka

Try this

coef =
CALCULATE (
    FIRSTNONBLANK ( Table2[Coef], 1 ),
    FILTER (
        Table2,
        Table2[group1] = Table1[group1]
            && Table2[group2] = Table1[group2]
    )
)

[Jay_Lu]

It works well, but just wonder why the lookupvalue function dosen't work?

[Jonathas]

I had the same problem, thank so much

[bharka]

it works, thank you @Zubair_Muhammad!

[Zubair_Muhammad]

@bharka

LookupValue should also work. Try this

coef =
LOOKUPVALUE (
    Table2[coef],
    Table2[group1], Table1[group1],
    Table2[group2], Table1[group2]
)