Forum Discussion
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...
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.
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