Row level security where multiple people can see a row

[ThomasWeppler]

Hi Power Bi community

I want multiple people to be able to see the same row.

usally I use this DAX: [email] = userprincipalname()
but it will not work if I have multiple e-mails in the colum. Is there a way to achive that?

All help is greatly appriciated.

[amitchandak · Accepted solution]

@ThomasWeppler , Better unpivot, if more than one column has email.

Or use Split by Delimiter to have email in multiple rows, if they in same column separated by Delimiter 

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

[Anonymous]

Thank @amitchandak  and @xifeng_L  for their prompt replies.

Hi @ThomasWeppler  ,

May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

Best Regards,

Ada Wang

[xifeng_L · Accepted solution]

Hi @ThomasWeppler ,

You can try below expression.

FIND(userprincipalname(),[email],1,0)>0

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[ThomasWeppler]

Thanks for the answer.

It looks like it might work. I will try it out for a bit and get back and accept your suggestion as a solution if it works.

[amitchandak · Accepted solution]

@ThomasWeppler , Better unpivot, if more than one column has email.

Or use Split by Delimiter to have email in multiple rows, if they in same column separated by Delimiter 

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

[ThomasWeppler]

@amitchandak thanks for the fast answer.
My problem is more how I wirte the DAX-code that let me look at row level security for multiple colums.

so let us say that I have
colum 1 = User A

colum 2 = Email[1]

colum 3 = Email[2]

How do I wirte a dax code that allow a both the person with Email[1] and Email[2] to see User A?

[Email[1]] = userprincipalname() will not do it.

I hope the question make sense.