Forum Discussion
Row Based Security On Muliple Values
I am trying to impliment below logic , however getting error: "A Table of multiple values was supplied where a single value is expected"
Opportunities[Worker_Id] IN {LOOKUPVALUE(ExternalWorkerMapping[Worker_ID],ExternalWorkerMapping[User_Id],LOOKUPVALUE(ExternalUser[User_Id],ExternalUser[EmailID],USERPRINCIPALNAME()))}
My Expected OutPut: Opportunities[Worker_Id] IN {1,2,3,4}
In ExternalWorkerMapping table, One to Many, one user may have multiple Worker ID's
I canot use Mappings because , like above condition, i have to impliment few more condition with OR condition.
Can you please help me in finding out a solution for my requirement
1 Reply
- parry2k
Super User
MokaSatya Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490