Tableau Target vs actual - data drop issue

Question

I am having a serious issue in tableau when comparing the current month value to the current month target. I am currently using data blending for this purpose. But this issue wont solve even if I use tableau relationship joining. I have 3 join clauses. Such as branch ID, Staff ID and Month/year. Pls see the below

Ex - january Target - 95,000

Actual - 126,000

But when 3 joining clauses created, its dropping data to 111,900.

the reason is in january, even the allocated branch ID and month is matching, the other staff id clauses are dropping off. That means even though the table A has all branches , staff ID's and date key, the txn table is having only one staff ID maching for January. If the 3 matches are not satisfying , data is dropping itself. How to solve this isseue? I need to show the total value of 126,000 infront of 95,000. not 111,900.

Hope anyone can help.

Many thanks

Answer 1

Seems like this could have been solved by changing the join type from an inner join to a right join.

Answer 2

This got achieved by a table unioning.