Lookup Multiple Values

[newpbiuser01]

Hello,

I have a primary table with a list of people, and the lookup table that contains a list of all individuals in the department (including but not limited to the people in the primary table) and the account number. I am trying to use the lookup function to get a list of different account numbers that each individual in the primary table is using. When I try to use the lookup function, I get an error saying multiple values were returned where only one was expected. Would anyone know if this is possible in Power BI?

Primary Table:

Name

A

B

C

D

 Account Table:

Name	Account
A	123
B	456
C	456
D	789
E	123
A	456
A	789
B	123
C	878
D	456
V	456
X	789
D	111
X	456
J	111
J	156
K	222

Result:

Name	Account
A	123
A	456
A	789
B	456
B	123
C	456
C	878
D	789
D	456
D	111

Thank you!

[newpbiuser01]

Thanks @Anonymous! That worked.

[Anonymous · Accepted solution]

Hi @newpbiuser01 ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

1. Create the relationship between Primary and Account table base on Name fields as below screenshot

2. Create a table visual as below screenshot

If the above one can't help you get the desired result, please provide more sample data in Primary and Account table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

How to upload PBI in Community

Best Regards