Forum Discussion
LOOKUPVALUE not returning result for matching data
Hello, I am trying to use the LOOKUPVALUE function across two tables to return a result of "Published" or "Unpublished." In data table 'Sales Data' I have a cell value 401211_US - Ferguson that ...
Similar problem here where despite using the same search data in the same calculated column, LOOKUPVALUE returned the correct data for some rows and blank value for other rows, what was driving me crazy.
After several try-error tests I found out that the table where LOOKUPVALUE was searching the data was affected by a filter in the data model from a third table, so solved the issue replacing Lookupvalue and using CALCULATE with ALLSELECTED to remove filters from the third table.
Must say I haven't found any documentation of this behaviour of model filters propagating in calculated columns. Thought it only happened in measures (and visuals and RLS, of course)