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 are there)
In the visuals, I have a table which has a list of unique CC's from the CC_KPI_Count table and the number of times that CC appears in the table. This is filtered by date (though the date is not shown).
I want to be able to make it so that if I click on a row in this table, I can see the data from the dat_files table, but only if the CC, Extract_Date and Staff_Number are all a match. From what I am seeing, it seems that the rows filtered are for any of these fields, not all. So I end up with results where its the correct date, but CC's that were not from the row I selected etc.
Is there a way to make relationships comming into a table filter so that they all have to be correct to show a row and not just one?
2 Replies
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?
