I need to filter à column by another Column in my RLS

[Guillaume_S]

Hi,

I have two tables and I need one to filter the other but i tried several methods and it doesn't work for apply my dynamic RLS.

I have already filter the list of CODE_CP (in tec_tab_regroupement) by the user email.

I need the list in the table Tec_Tab_Regroupement[CODE_CP] to filter a more complete list in the table Tec_bridge_Ref[CODE_CP].

Thanks for your help

Guillaume

[v-yueyunzh-msft · Accepted solution]

Hi , @Guillaume_S 

According to your description, you want ro set the RLS in another column with the dynamic RLS. RIght?

After you have set up dynamic RLS, you can create another role and set the RLS of the table Tec_bridge_Ref [CODE_CP], like this:

Then we can test in Power BI Desktop:

The result is as follows:

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly