Forum Discussion

bourne2000's avatar
bourne2000
Helper V
3 years ago
Solved

How to make relationship?

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?

Need Help
Show and Tell
  • vicky_'s avatar
    vicky_
    3 years ago

    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.

2 Replies

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

    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.

  • Thennarasu_R's avatar
    Thennarasu_R
    Responsive Resident
    3 years ago

    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