Lookupvalue not working as intended on two tables with same items

[Asina]

Hi, 

I am trying to use Lookupvalue to get matching data from another table.

I have 2 tables with matching column items (almost), meaning Table1 has column named: Hovedstation might have few more items than Table2 named: Hovedstation. However, the idea is to check the table2 and see if columns named: Hovedstation has a matching name, then it should call the a value from the column named: Ev_Procent. 

However, I am only getting 1 value matching 1 item on both columns...while the rest of the values shows as blank, even though they match in the item name......

While the hovedstation has more names Table1:

Does anyone know why is it showing values only for OST and not the rest, although we have matching names in table 2 see: 

Table2:

[Greg_Deckler]

@Asina LOOKUPVALUE tends to return BLANK if more than one matching row is found. MAXX(FILTER(...),...) tends to be a more reliable construct.

[Asina]

Hi Greg

I tried your solution, however it seems I am getting same result:

[Asina · Accepted solution]

Hi Greg, 

I found the solution, and it has nothing to do with MAXX(filter()) functions, I have also used those, and the result was similar. The problem lay in the table structure, which was formed in the DAX itself by using {x,
x,
x} 

Apparently Dax has some code problem when reading a table with space between the commas, as shown above...The sample has to be: {x,x,x} when making a column.

Thus the solution: Lookupvalue(X[value],X[item],X1[item]) works fine and it also works with more than one matching row. 

Regards