Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ivancolo96
Regular Visitor

IN with a LOOKUPVALUE

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

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

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

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors