Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

You can't create a relationship between these two columns...

So I get why this is happening even though they are the exact same numbers in both columns from both tables: There are duplicates in my CService table because since a company can have multiple...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    My mistake, there is a syntax error in my original DAX. Please use DAX below instead, replace CBIZ with your own table.

    NewTable = 
FILTER(
DISTINCT(
UNION(
DISTINCT(CBIZ[CompanyID]),
DISTINCT(CService[co])
)
),
NOT(ISBLANK(CBIZ[CompanyID]))
)



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,


Create a new table using DAX below. Then create relationship between the new table and the other two tables.

NewTable = 
FILTER(
DISTINCT(
UNION(
DISTINCT(CBIZ[CompanyID]),
DISTINCT(CService[co])
)
),
NOT(CBIZ[CompanyID])
)



Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous attempted to do this but it doesn't let me finish typing the formula out:

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous I'm sorry, it actually did work. Now I'm just getting this error message:

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous,

      My mistake, there is a syntax error in my original DAX. Please use DAX below instead, replace CBIZ with your own table.

      NewTable = 
FILTER(
DISTINCT(
UNION(
DISTINCT(CBIZ[CompanyID]),
DISTINCT(CService[co])
)
),
NOT(ISBLANK(CBIZ[CompanyID]))
)



      Regards,
      Lydia