Forum Discussion
Trouble Creating Relationships
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] )
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!
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
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.
I'd add a concatenated column as the key to all 3 of your tables, and remove the duplicates from your Name&group table.
Here is an example:
https://1drv.ms/u/s!AoqLdf_zgUezgawgy7a2jSOs7Syi4w
I can't access the file that you've created to have a look at it, sorry!
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
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] )OK found a solution.
Created an new datasource with only the names and that worked.
Thansk all!
