Forum Discussion
Solved
DAX 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?
Hi 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..)
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?
Hi AlexisOlson
As you said, I realized I had an active relationship between the tables that complicated it. Now works fine. Big thanks!