Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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~
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
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~
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.
@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
@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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |