Forum Discussion
Lookup value from one table from another
Hi Anonymous, sounds to me like you have selected "Add Measure" instead of "Add Column"?
Just check that you have used "Add Column" and done so in the table that will hold the CID Flag. In this case we are adding it to the CID Table.
I tried to replace the arguments and put it as :
CID Flag = IF( IFERROR( LOOKUPVALUE( 'Large Table'[CID], 'Large Table'[CID], 'CID Table'[CID]), 0 ) = 0, 0, 1 )
But, this is not working as the LOOKUPVALUE function is not allowing me to use 'CID Table'[CID] as the thrid argument at all. I can only see the columns of the Large Table for the third argument.
However, it is running when the previous query was used :
CID Flag = IF( IFERROR( LOOKUPVALUE( 'CID Table'[CID], 'CID Table'[CID], 'Large Table'[CID] ), 0 ) = 0, 0, 1 )
Could you please assist me here?
Also, it seem the third argument needs to be a single value so, when I try using a column of another table, its just showing me the option to choose another measure as the third argument.
Make the CID Flag a column in the other table, not the large table. Thats the only way to reverse it correctly. You will still be able to include it in your reports.
Thanks.. Anonymous
However, it is not allowing me to keep the third arguement of lookuptable function to use a table column, but, only measures of either tables. And, I tried in both ways.. for the larger as well as the smaller table.
Is there something that I might be missing?
Hi Anonymous, sounds to me like you have selected "Add Measure" instead of "Add Column"?
Just check that you have used "Add Column" and done so in the table that will hold the CID Flag. In this case we are adding it to the CID Table.