Forum Discussion
RLS based on user login
Hello, Anonymous,
in your RLS settings to your RLS table, write [EMAIL]=USERPRINCIPALNAME().
Then create a new column which weill be concatening Company and Dept together (this is optional, you can use as the key any of those withour creating new one), do it in your MAIN Excel and your RLS table, then create relationshisp Many to Many but don't make it both, but RLS filters MAIN EXCEL, key column is the new one.
and then whenever you use Company or Dept, use it from the RLS tabel as dimension.
Hi Anonymous
Try to make active relationship between Dept (domain) 1-> Dept(Main) many.
I hope this solve your issue.
If I answered your question.Please give kudos and accept it as a solution!
Thanks
i can only make one relationship active between 2 tables , in this case company is active, whichever relationship is active the RLS filters for it .
Hi Anonymous
You can keep another inactive relation between two table and use RELATEDTABLE dax as per your requirement.
Thanks
