Forum Discussion
Solved
Duplicate table visual rows.
I have 2 data sets\tables with a relationship (Many to Many with Both as cross directional) of "Country". I then create a table visual and all columns are from the same table (Carrier Table) and it ...
I managed to find a solution over the weekend to prevent the "Many to Many" relationship by creating a new uniqiue column in each table using...
Key = 'Carrier Matrix'[Region] & " - " & 'Carrier Matrix'[Country]& " - " & 'Carrier Matrix'[Carrier]and this created a 1 to many relationship and seems to work. It even helped me identify columns on either table that had mis-matching values, such as typo's as they couldnt create a relationship between tables. Once the typo's had been fixed or row content matched, duplicate columns vanished.Thanks for reply.
Unfortunately, cant share data. I pursumed that "Country" to "Country" would work as a relationship. What could I be missing?
I thought the "Country" column would be the ideal relationship link between the 2 tables, but have removed that relationship and tried a couple of differnt column relationships and the relationship between "Vendors" seems to work. Not to sure why this over country works and will have to test to make sure the data I want displayed is being displayed.
- country can be a good relationship but it wont make your line unique, what is the granularity of your model? The granularity being the level your data is sitting at. At the moment you joining on country - When you say they are duplicated why do you say they are duplicated?
