Row Based Security On Muliple Values

[MokaSatya]

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

[parry2k]

@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