Lookupvalue return blank

[Milan]

Hello community, 

i have issue with LOOKUPVALUE function. I have experience with LOOKUPVALUE, but behaviour of function in my project is freaky. I have column - storecard number in couple tables (storecards, images etc, around 20 tables). All using is working properly except store movements. If i ask LOOKUPVALUE in store movements for another data from different table, result is blank. Table storecard movements has 400k rows, i tried remove duplicates of storecard numbers (it is not make sence - where it was 1:1 and same result, it is blank... Columns, are same format... 

From other side is LOOKUPVALUE not working - as expected - asking in storecards table for result in store movements (A table of multiple values was supplied where a single value was expected.)

Does anybody have any idea how to do that?

Thanks for your help and time

Milan

[amitchandak]

@Milan , You can use related, relatedtable(with MAxX, sumx etc) for related table to move data across

Lookupvalue or calculated column to move data acorss

example

a new column in Table 2 from table , add join columns with && and ||

maxx(filter(Table1, Table1[Col1]= Table2[Col1]), Table1[Value])

You can also use sumx, concatenatex

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[Milan]

Sorry, i can´t upload pbix file.  So i took screenshoots of same data model, but it is working. Asking in Storecards_movements for data from Storecards. I my project is result blank. Where can be the problem?

UPDATE: I copy original big pbix file and delete all tables except this two (Storecards and Storecards_movements). And it is working, result is not blank... Where can be the problem? What can be the cause of not proper working of lookupvalue?