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] )
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.
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!