Forum Discussion

darshp1's avatar
darshp1
Regular Visitor
8 years ago

LOOKUPVALUE Randomly Returns Blank Values

I have a dataset with Names of volunteers and each one is given a unique ID number.  In another table, I have some contacts and in that table, there is a column of with the Volunteer ID of the volunt...
RandomKitten's avatar
RandomKitten
Frequent Visitor
7 years ago

I am also having this issue, where certain values are not returning results even though I've confirmed they do match data in the lookup column. 

 

I tried using TRIM to rule out any leading or trailing spaces, with no luck.  I've tried deleting the relationships to other tables in case that was interfering, but it did not help.  It works for 95% of the data, but the remaining 5% return blank.

DonalMc's avatar
DonalMc
Advocate II
7 years ago

I have the same issue. A lookup randomly returns blanks for some rows.

 
BrightWork Asset = LOOKUPVALUE('BW Assets'[bw_name], 'BW Assets'[bw_brightworkassetid], campaigns[_bw_brightworkasset_value])
 
I have sort by the _bw_brightworkasset_value column to prove they are they same.
 

  • namssa's avatar
    namssa
    Advocate I
    6 years ago

    Me encounter this problem. Me solve by turning off biderectional cross filtering on the table from which me was looking up from.  Me guess me can live without that. We make sactifices in life.  Should jus wrk.  Shame shame.  Naughty naughty 

     

     

    Did I help ou? please mark this post as answer if yes and remit @20000 bitcoin. Else, bwlo me