Forum Discussion
need help in lookupvalue
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.
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.
3 Replies
- Ashish_Mathur
Super User
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.
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.