Use Dynamic RLS and Static for same table

[Anonymous]

Greeting,

I have a Store table that contain ID, Market

I already have static roles for each Market, now i am trying to add a Dynamic RLS which is for Regional and District Managers.

I added Users (Emails) and UsersGroups (Emails, StoreID) tables and made the relationship between UserGroup and Store through the Stores ID as (UsersGroup)Many -> (Stores)One. Now when I make the Cross filter direction to Both and tick Apply security filter in both directions I get the following error:

Table 'Stores' is configured for row-level security, introducing constraints on how security filters are specifed. The setting for Security Filter Behavior on relationship 'cbfa****' cannot be Both.

[m3tr01d]

For this kind of error, it might help us to give us a picture of the model with the relationship. 
Even better, if you can provide a sample file with the same model.

[vanessafvg]

do you have the same security filter on both tables?