IN with a LOOKUPVALUE

[ivancolo96]

Dear all, 

sorry if it will be an easy question ...

I should realize an IN condition based on a LOOKUPVALUE.
In a table i have a list of user and all the company they can view and of course i need

to filter fact data.

Previously a user accessed only one company and the filter was like this:

='Company'[SOC] = LOOKUPVALUE(USER_SOC[SOC] , USER_SOC [userID], USERNAME() )

How can I "change" the = with an IN condition?

Thanks

[TomMartens · Accepted solution]

Hey @ivancolo96 , 

maybe you want to give this statement a try:

'Company'[SOC] 
IN
SELECTCOLUMNS(
	FILTER(
		USER_SOC
		, USER_SOC[userID] = USERNAME()
	)
	"SOC" , USER_SOC[SOC]
)

Regards,

Tom