Forum Discussion
need help in lookupvalue
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.
Super UserHi,
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.