How to make relationship?

[bourne2000]

Hi

I have three tables called project started, project finished and date table

Project started and Project finished has been connected through date table. Project started table has total projects and project finished as total finished projects.

I created below visual by taking month from date table and project startes from project started table and project finished from project finished table

I have project code in both project started and project finished table. I would like to filter the projects and see how many projects started and finished. 

I created slicer by dragging project code from project started table. Filter only works for project started in the graph and total project finished ibar is not changing. Same If I drag project code from project finished table, bar is not working for project started. It remains static.

Can anyone advise how to make a common project code filter?

[Thennarasu_R]

@bourne2000 
Tyr with Cross filter function I will help this scenarios

CALCULATE (

            [Measure],

            CROSSFILTER ( Project Finished[Column Name], Projecyed Startes[column Name], BOTH )

Thanks,
Thennarasu

[vicky_ · Accepted solution]

I believe this is happening because of the direction of your filters. Notice that the arrows on the lines point away from the date table. This means that the filters applied to the date table will filter the other tables. But the project code doesn't exist in the date field.

I think you can either change the cross filter direction to both ways (double click on the relationship line to get this popup and then select cross-filter direction both

Or you can create a relationship between the project code fields of the two tables.