Unable configure RLS properly with two fact tables

[Anonymous]

We have two fact tables mapped with date and created summerize tables for each attribute as dim table(account name,employeeid,country) inorder to use in the slicers, we have one more dimension table Account manager for RLS,

when RLS table mapped with Table A, table A related report is working and table B report is also working, but when we choose vol or Invol in the slicer then visuals are breaking ,,,,,

simillarly if we map RLS table with Table B , Table B report is working slicer choose also working but Table A report is not working..

Please any one can help with scenario how can get the solution..

[Anonymous]

we have emailid each row in fact table(Table A) and we tried with bi directional,

Then Table A report is filtering based on RLS role, Table B data report is not filtering when we select vol/Invol in slicer

[CoreyP]

I'm not totally clear. So you have an RLS table, which is a table of employees? And this table relates to your fact table on... a category? or each row of your fact has an e-mail associated? It almost sounds like you need to change your relationship to bi-directional.