Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SevsBo
Helper V
Helper V

Lookupvalue not returning all results, but relationship based table is correct?

I have problem with Lookupvalue.

 

I have two tables: Campaign & Events. In both there is the column "ID", which pertains to campaigns id. The Campaigns table has Campaign Name in it, which I wish to have visible next to specific events, but Lookupvalue only picks up a few campaign names out of all available, even looking in Table View.

 

If I build a relationship between the two tables using ID as the connector, and create a table of Events a a visual, then drag the Campaign Name from Campaign into the table as a column on the visual, it populates fine, so there is no issue of there being wrong IDs in the ID columns. But if I build the following Lookupvalue, I only get partial results:

 

Event Campaign = LOOKUPVALUE('Campaign'[campaign_name], 'Campaign'[ID], 'Events'[ID])
 
Any suggestions?
6 REPLIES 6
parry2k
Super User
Super User

@SevsBo so a relationship is not possible and then use the related function to get the campaign name, you never replied on that option.

 

Regarding Lookupvalue, no idea why it wouldn't work. Very hard to tell without looking at the data. If possible send trim-down version of your pbix file, remove sensitive information before sharing.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Oh, I thought my answer regarding using the Related option was clear from my first reply - that we are getting a circular reference when using relationships so we cannot build one to use Related with.

 

Cannot share the data I'm afraid, was hoping there was a known issue with Lookupvalue that I could reference.

parry2k
Super User
Super User

@SevsBo I think that is a bigger problem, can you keep the relationship and use RELATED to add a column, or relationship is not possible at all?

 

Although I'm also not sure why LOOKUPVALUE will not return the result.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

I agree it's a bigger problem, but again due to time constraints we can't redo the whole model - or otherwise integrate this data in. So understanding what could be causing the lookupvalue issue would be very beneficial.

parry2k
Super User
Super User

@SevsBo why do you want to add a column in the Events table when you can achieve the same with the relationship which is the right approach.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Because we are getting a circular relationship with this table due to the complexity of the model. So the easiest solution is to actually append the data straight to it in this case, as it's not a large dataset. Otherwise we will have to re-model the whole model, and time constraints don't allow for that.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.