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...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have this problem too, where I'm using lookupvalue but for some results it always returns blanks even though I know data is present. And I can't figure out what's wrong since it works for maybe half the data so I don't think it would be a problem in the relationships.

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