need help in lookupvalue

[Anonymous]

I trying to figure out how the lookup value work in power bi...can anyone help...

I have 2 tables.

Table 1
Name	Team
John	A
Apple	B
Jane	C

Table 2
Team	Target
A	1000
B	4000
C	6000

how should i write the formula so that the following can be achieved?

Final Results
Table 1
Name	Team	Target
John	A	1000
Apple	B	4000
Jane	C	6000

Thank you.

[Ashish_Mathur · Accepted solution]

Hi,

Assuming there will only be unique entries in the Team column of Table 1, build a relations from the Team column of Table 2 to the Team column of Table 1.  To your Table visual, drag Team and Name column from Table 1 and write this measure

=SUM('Table 1'[Target])

Drag this measure to the visual.

[Anonymous]

@Ashish_Mathur 

Thanks, I got it.

[Ashish_Mathur]

You are welcome.  If my previous reply helped, please mark it as Answer.  If the relationship is set up properly, the RELATED() function should work.