Linking columns between tables through the use of a measure

[U156531]

I have two queries in PBI report that I need to merge into one visual. There is a common field between the two tables but I can't seem to get the correct values when I attempt to link the queries through manage relationships. Is there another way to get the values from both queries into one visual? Can I do this through a Measure? If so what Dax function would I use?

Thanks

[Anonymous]

Hi @zklagge ,thanks for the quick reply.

Hi @U156531 ,

Regarding your question, perhaps you can use the 'LOOKUPVALUE' function for your purpose.

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

[zklagge]

If you're struggling with aggregations in DAX, it might be prudent to try and join the two in PowerQuery, that can often be a bit more straightforward/is easier to identify where/how the join fails.  

Beyond that, if you could provide more information about your problem (perhaps the field types, is the relationship many-many, etc) that might also someone to do more thorough solutioning.