Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Trouble Creating Relationships

  HI all,   I've tried the solutions that I've found in previous tickets but it still won't work for me. Everytime I want to create a relationship between the different sql tables I get the error...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may add a new table and build relationship on the concatenated column.

    Table =
ADDCOLUMNS (
    DISTINCT ( 'Name&group' ),
    "Name | Group", 'Name&group'[Name] & " | "
        & 'Name&group'[Group]
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey,,

    I’ve read your article about creating relationships, tried again with the things I’vee read but still I’m ,ot able to create a good relationship.

     

    regards

    • MattAllington's avatar
      MattAllington
      Community Champion
      8 years ago

      Do you have a single column in the name and group table that has unique values?  It doesn't look like it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi,

         

        I've got a colum in the Changes table named 'Assignee_full_name' wich contains the names from engineers. The same names are also in the table Tickets in colum 'Assignee'. 

        And in the table Name&Group the 'Analyst_name' colum has also those values.

         

        What I want to do:

        - I'm creating an dashboard with the number of tickets and changes on it, via a slicer I can select an engineer and it must provide me the number of tickets and changes that only this engineer has handled.

         

        so the slicer will have the field: Name&Group>analyst_name.

         

        But before it can show me the data it must have a link towards the other tables.

         

        Many thanks for your help!