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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Kudoed Authors