FILTER formula giving #N/A

[greekness1]

Created a dynamic array with the UNIQUE(FILTER combo and it keeps returning #N/A. The table being referenced is static data or values being pulled from an ERP system directly into Excel. However when I add a third parameter to filter on $R$5 in column W:W of that table, it results in #N/A. The differences with column W is that it was added to the table and is not a column of values, but rather an XLOOKUP pulling data from another sheet. Is the #N/A due to column W not being hard coded values and being added to the table?

 

[hagia_sofia]

Is it possible that there are some errors (e.g. #N/A) as a result of XLOOKUP within column W (it has a parameter to address these)?