How to show zero in measure when relationship does not exist

[sidexcel]

I am trying to build a budget vs actual matrix table and running into a problem.

Tables:

I have following tables:
1. General Ledger Table

2. Budget Table

3. A few dimension table, the one relevant to this question is Vendor table. 

Relationships:

"Vendor" table has a relationship to the "General Ledger Table" but not to the "Budget Table". 

Measures:

Actual $ = sum(General Ledger Table[amount])

Budget $ = sum(Budget Table[amount])

Visual

Trying to create a matrix visual that has the following hierachy on rows:
Account Name, Vendor Name

The Problem

As seem in the screenshot, because there is no relationship of Vendor with Budget Table, the vendor names are repeating. I don't want them to repeat, I want them to only show up if there is a  value in the Actual $ column. 

[v-yalanwu-msft]

Hi, @sidexcel ;

I am not quite sure what columns your three tables have, and then the two tables you mentioned are related, so which column is the relational column? I can't reproduce this model, or you can share a simple example file to remove sensitive information. So that I can better recover similar data structures and give you detailed answers.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.