Budget (Target) Allocation, without relationship

Hi,

Yes, I know it is quite difficult to understand, I did create a sample PBIX until I realize I cannot attach it in here.

However, here it is :

https://drive.google.com/open?id=1r4gB17N_jiqL9qZt3SLkBonaElprB6W7

Anyway, the transition from Yearly value to Monthly is not the issue, it is already correct as they are.

What I want to achieve or the main issue is later when you see my PBIX, I have this table visual which contain :

- Year

- Region

- Branch

- Target Value

Then I have a Resource table, it is a list of Worker, which it has the info of their branch. (Resource branch)

So, I want to add this Resources to the 1st table visualization, but it needs to match the branch code of the 1st visual, so it only display the Resources belong to the branch in the respected row.

The matching is something like this :

So table visualization no 1, for row no 1, because it says the branch code is 109, it will only listed Resources (from table no 2) with Resource branch 109, which is Julia Funderburk. The target value may remain as it is.

For row no 2, Branch is 110, the Resource only 2, Jack Robinson and Julia Anderson.

For row no 3, Branch is 112, the Resource are 2 also, with colored green. 

and so on.

What I have now, all worker in Resources are listed in my Table visual.