Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Relationships not working properly when filtering

Hello all,

I'm having an issue with displaying data from two fact tables, that need to be filtered by one dimension table.

It's filtering for one table but not the other.

Both relationships are bi-directional. 

Both fact tables are related by the 'BranchPlant'

 

Please help

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , based on this, it should filter both, Unless you are using a measure that uses all or allselected for one of the table.

    Or stopped interaction for one visual

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , based on this, it should filter both, Unless you are using a measure that uses all or allselected for one of the table.

    Or stopped interaction for one visual

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak Thank you.

      I think the measure is my issue. 

      However, I did try with other columns too, in vain.
      I will try to merge the tables in SQL.

      Thanks for the advice.