How configure RLS with OR condition with 6 dimensions on 2 fact table

[Cobra77]

Hello

I had succeeded with a single safety table to make one or on the 4 dimensions.
Now I have a new problem.
I add 2 additional dims identical to the 4 others but these are linked to another fact table.

and I would like to always keep the OR on the first 4 linked to fact table 1 and add an OR between the other 2 dims on fact table 2.
Example in the files below:
The user titi@toto.fr must be able to see the lines
- or there is at least once pink on the 4 dim connected to the fact table 1
- or there is at least once pink on the 2 dim connected to the fact table 2

On the test_rls_OR_2_Fact file, if I only select the RLS on the 4 dims:

it works, except with a non-existent color which returns the line to me suddenly :

if I select all the roles it doesn't work anymore.
It returns all the rows from all the fact tables to me.

source sample pbix :
https://1drv.ms/u/s!AmluE3Tt6h4WgjicNxee8rMg12fH?e=g8OYFB

Thanks for your help.

[amitchandak]

@Cobra77 , when you want And, have conditions in one role. When you want OR have conditions in separate roles. When you use two roles they will be or.

[Cobra77]

Hi @amitchandak , thank you for your reply.

they are separate roles, yet if I combine them all, the fact that they are on 2 fact tables? , blows me all the rls

If I only use the first 4 roles on the main fact table it's ok for the OR

could you look at my example and tell me what's wrong ? 

Thanks

[Cobra77 · Accepted solution]

I found,

a combination between the dim of the 1st fact table and the 2, we get here 8 roles