Forum Discussion
Post PatronLookupvalue returning the complete column in blanks
Hi,
So I have this fact table which unrelated to a lookup table, and I am extracting values from the latter using the lookupvalue.
The thing is that I am getting all blanks, and I have no idea why. Some Ids are only in the fact table, but I am using 0 as the alternative result. What is going on here?
Ideas?
Thanks!
5 Replies
- dedelman_clng
Community Champion
Hi campelliann - can you provide the code you are using, along with a sample of your data? Hard to know what is happening without specifics.
Or better yet if you can share a copy of your pbix with sensitive data removed. Use OneDrive, Googledrive, dropbox, etc to share a link.
David
campelliannhi dedelman_clng, thanks for your reply. The problem is that the complete file is sensitive. I did a new table, where I filtered the IDs from the first Table, to get only those who are common in both tables. In this way the lookupvalue worked. It seems the cause were the IDs that were non-existent in the table from which I am extracting the field.
Does this help?- dedelman_clng
HI campelliann - can you provide a screenshot of the table structure (from the model screen, not the data) and the code you are using with LOOKUPVALUE ? It may be a simple fix that doesn't require creation of a 3rd table to work.
