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 t...
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.

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