Forum Discussion
stevejpage
9 years agoFrequent Visitor
Relationship Problems
Good afternoon all: I have a series of tables between which I am trying to manage relationships. These five tables have several columns that have entries between them that are the same and on an ...
stevejpage
9 years agoFrequent Visitor
GilbertQ
9 years agoSuper User
Hi stevejpage I would suggest changing the Relationship direction from Both to Single, that should then eliminate the duplicates coming through?
- stevejpage9 years agoFrequent Visitor
No joy on eliminating the duplicates. I know there's a way to get the data I'm looking for, but maybe Power BI just doesn't do it.
- GilbertQ9 years agoSuper User
Just to confirm that you changed the Cross Filter Direction to "Single"?
- stevejpage9 years agoFrequent Visitor
Yes, I tried chaning a number of the cross-filtering one at a time, and wound up with less data than before.