Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
76 | |
72 | |
65 |
User | Count |
---|---|
140 | |
109 | |
103 | |
82 | |
73 |