Table Filtering

[chad_clift]

I have a powerbi semantic model with 2 tables that are related to each other. One table is addresses and the other is accounts. When using a table visual, I can filter for 2 IDs that show up when i display only the address dimensions, but as soon as I add a field from the accounts table, it only displays records that are visible in both tables.  Looking for help to ensure that if there isn't a record in the Accounts table that it displays a blank value.

Below is my relationship.

[chad_clift · Accepted solution]

right click on a field it in the build section and "show items with no data".