topic Re: IN with a LOOKUPVALUE in DAX Commands and Tips

IN with a LOOKUPVALUE

ivancolo96 — Tue, 17 Dec 2019 16:30:45 GMT

Dear all,

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 — Tue, 17 Dec 2019 18:33:34 GMT

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