Net Account Opening

[StevenH417]

Hello! I am new to Power BI and trying to start with something simple, but am having a bit of trouble. I am trying to create a net account opening visual by location. I have two reports coming in to get the data, an account opening table and account closing table. I have filters set on the page for the dates these were opened or closed by month. 3 Visuals; an opened total, closed total, and net. My problem is that I had to create a relationship in my tables for the locations to connect properly. But now, if I don't have a value in my open table or closed table for that location based on the filters, then that location doesn't appear at all in any visual. For instance, Location A has 0 accounts opened, 3 accounts closed, and a net of -3. But Location A doesn't appear at all in any visual since there isn't any information for it in my opened table for the month. Can anyone help me straighten this out?

Thank you!

[SergioSilvaPT · Accepted solution]

Hi @StevenH417 ,

For that i recommend for you to create an aditional table with the distinct locations and connect both, open table and closed table to this new table, and use this table to filter by location.

You will need to have all the locations that you have in both tables but without duplicates.

If you need i can guide you to do that.

[StevenH417]

So I'm just thinking this through. In this third table I would basically include columns that would give me my total opened and closed for the month that sum from the other two tables and get my net in it? My original two have a line for every account opened and closed.

EDIT: I was making this way to complicated. I think I have it. Thank you for your suggestion! Table relationships are new to me.