Forum Discussion
Cannot create relationship
Try setting the cross filter direction as single
It does not give me this option - it says that one of the two columns must have unique values. I have removed duplicates and checked this many times but no luck!
Any ideas?
GCGradwell This can be extremely frustrating, but I haven't come across this scenerio yet, where there wasn't a duplicate. Have you searched for and eliminated any hidden characters? Carriage returns, etc? Sometimes a simple action to remove blank spaces will ignore these in the database, causing major headaches.
Unless the dataset is small enough that you've manually gone through and checked them all, then ignore me :)
But in my experiance, it is something like this and there is one duplicate in the bunch.
For really stubborn sets where you're sure there are no duplicates but Power BI insists that there are, you can write a measure to check.
Duplicates = COUNTA(TableName[ColumnThatShouldn'tHaveDuplicates])
...assuming it's a text column. If it's a numeric column use COUNT instead of COUNTA. Anyway the important part is do not use DISTINCTCOUNT. Now, put that column on a table or matrix visual and put the [Duplicates] measure with it, sort descending by [Duplicates] and the duplicated values from that column will be on the top.
Are there already other relationships between these tables and other tables in your dataset?
