Forum Discussion
Switch Active Relationships When Using Measure - Recent change in behavior of USERELATIONSHIP?
Hi gurus- my visuals used to work just fine. At some point, they stopped displaying the intended information and the underlying engine is changing how the visuals are querying the data. Scenario ...
It would appear that your other relationships with the filter direction set to both are causing the issue?
I would suggest looking to see how to remove the cross filter direction being set to single.
Thanks for the suggestion! I honestly don't know much about that feature nor do I understand why this would be turned on vs turned off. I'll try turning off and testing the behaviors again! Stay tuned
Turning off cross filtering causes row level security to break and allows the user to see all records from [File - Signing Info] even though they do not have a relation to those in the [File - Security].
Any other suggestions?
l would first try this and if it works, the you might have to relook at how the RLS is being implemented?
