Forum Discussion
jereaallikko
Helper III
Helper IIIDAX Measure to Check Tag From Different Table
Hi all, I am trying to solve a problem with relationships and column mapping from other table. I have two tables, both containing hundreds of rows of data. I have created a simple illustration da...
I'm not sure what you're doing wrong but it works fine for me.
Do you have relationships between the two tables complicating things?
jereaallikkoHelper III
Helper IIIHi AlexisOlson,
Thanks for the reply.
This solution is one step closer. Problem is that this works only for those where Table1[Product] = Table2[Product]. Not if the field in Table1[Product] contains more characters, or two products. See below:
As you can see, it does not map for differently filled fields (Bert.5, XMAN_1, Bert.5 etc..)
AlexisOlson
Super User
Super UserI'm not sure what you're doing wrong but it works fine for me.
Do you have relationships between the two tables complicating things?
- jereaallikko
Hi AlexisOlson
As you said, I realized I had an active relationship between the tables that complicated it. Now works fine. Big thanks!