How to manage relationship with multiple table

Hi Power BI Community Team,

By monthly performance tracking of sales rep, I have 05 tables as the following below:

1. Sales Order (Generated/Export from system, Only have material code)

2. Monthly Sales Target

3. Category Group of Product (02 kinds of sales rep --- by Category & by Client)

4. Purchased Rate % (input the result manual of target & actual)

5. Calendar Master

When I am trying to connect all these table together, some tables can and some cannot. 

May I need your help and suggestion to connect it all? And expectation of result are similar the screenshot below that we can choose the month and able to see the target, actual...etc

Sample pbix & excel - https://drive.google.com/drive/folders/16t11FvgLUfdUcvZC3o2FQe0Cnqshrve0?usp=share_link