cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mohammed Member
Member

filer does not Contains many values

Hi everyone,

I need Help

I want to filer does not Contains many values in power bi, such as  filer does not Contains values  X,Y or Z 

 

Reagrds,

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: filer does not Contains many values

@mohammed ,

 

Drag measure below to Visual level filters and set Show items when the value is 1.

Measure =
IF ( SELECTEDVALUE ( Table1[Column1] ) IN { "X", "Y", "Z" }, 0, 1 )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User
Super User

Re: filer does not Contains many values

Hi @mohammed 

 

You can use

 

Filter(TableName, Not TableName[Col] in {"x","y","z"})

Highlighted
mohammed Member
Member

Re: filer does not Contains many values

@Zubair_Muhammad 

thanks, but you mean to use your solution as a new table or new column or use it in the visual filter,

I want to help me to use filter inside the visual filter, I used table visual and add 3 columns, inside table I want to filter based on a specific column not contain some values, such as not include X,Y Or Z

Community Support Team
Community Support Team

Re: filer does not Contains many values

@mohammed ,

 

Drag measure below to Visual level filters and set Show items when the value is 1.

Measure =
IF ( SELECTEDVALUE ( Table1[Column1] ) IN { "X", "Y", "Z" }, 0, 1 )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.