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

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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I can't access the file that you've created to have a look at it, sorry!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      if you add an concatenated colum how did you do it?

      And removing the duplicate names in my names&groups table, wouldn't dit result in an loss of data?

       

      Some names are indeed 3 or more times in the name&group table but it's because they also appear in different groups.

       

      Pfff really stuck on this