Reg - Lookup Issues

[PavithraShan]

Hi,

I have a relationship between two tables Table A and table B. I couldn't take lookup from table A field to table B. Is there any solution to take lookup?

It generates an error like this,

[dax · Accepted solution]

Hi @PavithraShan , 

I think this is caused by multiple rows match, if multiple rows match the search values and in all cases result_column values are identical then that value is returned. However, if result_column returns different values an error or alternateResult, if supplied, is returned.

 So you could add alternateResult to remove error. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.