Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to 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
@Asina LOOKUPVALUE tends to return BLANK if more than one matching row is found. MAXX(FILTER(...),...) tends to be a more reliable construct.
Hi Greg
I tried your solution, however it seems I am getting same result:
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