Forum Discussion
Filtering table by multiple relationships from bridge tables
I have a situation where there are 2 tables, both have 3 fields in common which are CC, Extract_Date and Staff_Number (see below, you can't see all fields in the dat_files table, but those 3 fields a...
MichaelWitten , Please all these join single directional and the try to activate the inactive join. Then it should work. As of it creating loops or multiple path because of bi-directional joins
There are no inactive joins and the joins are bidirectional, they need to be. The only issue is the way they affect the results. I want them to join like in an SQL statement you would use an inner join, but its doing it like a full outer join. Or in an if statement I want it like it was an AND where its acting as an OR. I believe its just the native way powerbi does its relationships, I was just wondering if there is somewhere you can change this for a particular table?