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
Dellis81
Continued Contributor
Continued Contributor

SSRS user forum?

Hello

 

I am seeking help for PBI Report Builder - which forum is best to post questions?

thank you

 

Within the dataset filter - I am wanting to use a NOT contains filter.   I have attempted the custom expression option, but to no avail.

 

SSRSwipFilter.PNG

 

I would appreciate advice on converting this to a "NOT Contains"

thank you!

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

Hi @Dellis81 ,

If I understand correctly, it seems that you want to filter the data which not contains some specific values. Am I right? If yes, you can refer the following links to get it:

Working with Reporting Services Filters – Part 4: Creating a NOT IN Filter – Data Inspirations

=Iif(InStr(Join(Parameters!FilterList.Value,”,”),Fields!Category.Value)=0,True,False)

sql - How to implement 'Not In' Filter in SSRS? - Stack Overflow

=IIF(Array.IndexOf(split("30,31,32,33,34,35,36,37,38,39",","),
CStr(Fields!YourField.Value))>-1,"Exclude","Include")

SSRS : Simulating NOT IN and NOT LIKE Functionality In SSRS Filter Expressions - TechNet Articles

vyiruanmsft_3-1683178086159.png

vyiruanmsft_0-1683177994841.png

vyiruanmsft_2-1683178043959.png

In addition, you can apply the codes in the data source query as below:

WHERE  Production.ProductInventory.ProductID NOT IN (@ProductID)  

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @Dellis81 ,

If I understand correctly, it seems that you want to filter the data which not contains some specific values. Am I right? If yes, you can refer the following links to get it:

Working with Reporting Services Filters – Part 4: Creating a NOT IN Filter – Data Inspirations

=Iif(InStr(Join(Parameters!FilterList.Value,”,”),Fields!Category.Value)=0,True,False)

sql - How to implement 'Not In' Filter in SSRS? - Stack Overflow

=IIF(Array.IndexOf(split("30,31,32,33,34,35,36,37,38,39",","),
CStr(Fields!YourField.Value))>-1,"Exclude","Include")

SSRS : Simulating NOT IN and NOT LIKE Functionality In SSRS Filter Expressions - TechNet Articles

vyiruanmsft_3-1683178086159.png

vyiruanmsft_0-1683177994841.png

vyiruanmsft_2-1683178043959.png

In addition, you can apply the codes in the data source query as below:

WHERE  Production.ProductInventory.ProductID NOT IN (@ProductID)  

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your response and thoughts.   I will see if I can make one of your suggested links work.  I had previously searched, but seems the 1st option is a little more clear than what I had experienced before.

 

Will get back in touch - probably this weekend.

thanks

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors