topic Re: Lookup Multiple Values in Developer

Lookup Multiple Values

newpbiuser01 — Wed, 13 Apr 2022 19:54:21 GMT

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

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!

Re: Lookup Multiple Values

Anonymous — Mon, 18 Apr 2022 06:19:45 GMT

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

Re: Lookup Multiple Values

newpbiuser01 — Mon, 18 Apr 2022 13:27:23 GMT

Thanks @Anonymous! That worked.