Forum Discussion
Visual Filter error dues to inactive relationship
Hi Guys!
I have this measure that uses two different tables: [THA] comes form table [robotic data] and [primary hips] comes from [total sales by year] table. They both have column [region name], however that connection is inactive and I can't seem to activate it. I tried using USERELATIONSHIP function inside this measure to make the connection active but it didn't work, because the measure is not filtering on any regions. However, I need to add Regions as a filter on a visual and that's where the problem is becuase it's not calculating correctly becuase of that inactive connection. Please help!
2 Replies
- amitchandak
Super User
Anonymous , you should be able to create one active relation. If all relation is inactive, try to active one and check the error.
It could be because bi-directional join. make some of them single direction and check
- AnonymousNot applicable
I can't seem to make any direct active relationships between the two as it messes up the existing relationships between other tables and I don't want to deactivate them since they're used for other things