One to Many Relationships and Filtering

[Anonymous]

Hello -

I have two tables with a one to many relationship, and I have filters applied to both tables.

Table 1   Table 2

1              

2              2

3              3

4              4

5              4

6

If the filters are "Table 1 is not 6" and "Table 2 is not 2" it returns:

Table 1   Table 2

3              3

4              4

Is there any way that I could also have this return 1 and 5 in Table 2?  

I want Table 2 to only remove items from Table 1 that are in the filter, but if the items don't exist in Table 2 but do exist in Table 1 I want them to still be present in the results.

The kind of behavior that I am talking about works in a 1-1 relationship, but in a 1-1 many it does not.

Thank you for your advice.

Elizabeth

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may Use performance analyzer in Power BI Desktop to check query and take a look at Show items with no data in Power BI.