Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter for two table but relationship remains Inactive

Task is the main model, In queries I used duplicate/reference to create Table (3). I linked both of them to Calendar table as I had to prepare planned vs actual bar and line charts. From Task I ta...
  • v-eachen-msft's avatar
    6 years ago

    Hi Anonymous ,

     

    From the screenshot, you have got an active relatinoship between "Area" and "Tasks"( "Area"-->"Tasks 3"-->"Calendar"-->"Tasks").

    So you need to set one or all of "Both" relationship to "Single".