Strange behavior with slice

I’ve got a slice
3X_2_e_2edeba1e79e6337d9a5cbc55c20fa8d9ccea157f.png
In my slice i’ve got a row filter condition :

IN([Mod_ID],ANY(SELECT(Variable[Var_V_ACCESS_L],[Var_Mail_ID]=USEREMAIL(),true)))

Variable : is a table that for each user contains his own data, the key is USEREMAIL
Var_V_ACCESS_L : is a virtual column that contains the list of module the user can access

This slice display for each user the modules he can access

When i test this slice, it works well. i’ve got this
3X_d_4_d43b029585b1decfaa3c0b33c2a8e7b76bd6444f.png

This is good , i can access to the 2 first module

But on the view using the same slice
3X_f_8_f87c9e06b8b67b8b6b96f34ed385909040151b15.png

Only 1 line is displayed !!!

3X_b_d_bd1ee2a182a45a2b12c4db6b98e0240d335e9c13.png

I should see the first 2 lines, exactly the same has the test done before directly on the slice

If i use the table in this view and not the slice
3X_6_2_620843c4ca6498be7fa7f62ac0ce23e3ea0b8a17.png

All the applications are displayed

3X_c_0_c08fb130f65f77c243e24547b7274ac58e35e2ef.png

I’ve checked in the documentation and slice can use virtual column in their condition
Do you know where i need to check ?

0 10 237
10 REPLIES 10
Top Labels in this Space