topic RLS for Multiple emails in a same row to see same data in DAX Commands and Tips

RLS for Multiple emails in a same row to see same data

Anonymous — Tue, 04 Mar 2025 08:06:09 GMT

Hi
i have multiple emails in a same row, need RLS for the beow requrirement

example- apple,car,banana, ornages should see same set of data as below screenshot
Pen,train, shop ,food should see same data when they open PBI report individually or login individually

> i have email column in only one table (from souce also there is one table only , no joins or no relationships )

Re: RLS for Multiple emails in a same row to see same data

weiqb — Tue, 04 Mar 2025 09:50:24 GMT

hi，you can use find function.

Re: RLS for Multiple emails in a same row to see same data

Joe_Barry — Tue, 04 Mar 2025 11:01:42 GMT

Hi Anonymous

I use

CONTAINSSTRING([Email], USERPRINCIPALNAME())

Joe