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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Ok to make it more visible I've created some example data.

      (I can't share the original files due to company information)

       

      Here you can find the example data

      Data

       

       

      I've also made a dashboard like I want to have.

       

      In short:

      - I want to get an general overview about how many bikes and mobilehomes are selled

      - It must be filtered with date (so I want to view it in a timespan)

      - It can be filtered on name or group

       

       

      I hope someone can give me a helping hand.

       

      I know this data came from an xls file, in my original request it's from an sql reporting database.