Lookupvalue with two conditions

[AFra]

Hi All, 

I wave two tables such as : 

TABLE 1 : 

ID PROJECT	Status
project1	A
project2	B
project3	C

TABLE2 : 

ID PROJECT	Steps	#Houses
project1	A	20
project2	A	22
project3	A	40
project1	B	65
project2	B	60
project3	B	35
project1	C	100
project2	C	110
project3	C	120

I would like to add a new column in table 1 that reports #houses based on the ID PROJECT and the Status. Expected results : 

Table 1

ID PROJECT	Status	#Houses
project1	A	20
project2	B	60
project3	C	120

Should I do this with a multiple condition lookupvalue? Or there's an easier solution? 

Thanks in advance for your help!  

[az38]

@AFra 

you can create relationships between table by Status - Step field, then add Houses column to visual and set aggregation (in visulization Pane) as Maximum or Last

But, if a few projects can have the same status, create an Surrogate key in both of tables, like

SurrogateKey = CONCATENATE(Table1[Project], Table1[Status])

and

SurrogateKey = CONCATENATE(Table2[Project], Table2[Step])​

and create relationships by this field

[AFra]

Ok, simple and effective 🙂 

Thanks a lot!