Lookupvalue Missing Values

[mikesqu]

Hi all, 

Hopefully someone can help me with this issue. I have two tables, joined by a source name. On the secondary table I have the source media stored, so I am using the following formula on the main table, however it is not pulling through for each of the records. As you can see below only 1 of the Googles is showing as PPC, and 1 of the Referrals as Inbound; why would it be missing the others?

Media = LOOKUPVALUE(Source[Media],Source[Source Name], 'Clients'[Source])

Thanks for any assistance

[mikesqu · Accepted solution]

FYI I just duplicated the source table and the lookupvalue worked perfectly. Must have been a bug in the system. 

[v-henryk-mstf]

Hi @mikesqu ,

If you look at the formula alone, it should be caused by no query result in the target table (Source[Source Name]). You can refer to the following blog for a detailed description of this function.

Power BI LOOKUPVALUE | Examples of LOOKUPVALUE Dax Function (wallstreetmojo.com)

Also, if the problem still exists, can you provide the relevant test data and describe it, so that I can answer it for you as soon as possible.

Looking forward to your reply.

Best Regards,
Henry

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

[mikesqu]

Hi Henry,

This is what I don't understand. The image below is directly from the clients table, showing that the new media column using the formula above is not recognising that the both cases of Google - Desktop are the same, as well as the three referrals.