Filtering Column with Text which contains Parentheses

[Anonymous]

Hello everyone.

I am working on a data which I need to filter based on a text, which basically has a parenthesis in it. 

Like Dogs (not Cats).

So if I write my filter like this:

FILTER(Animals, Animals[Type] = "Dogs (not Cats)"),

the parentheses, which is part of the text is ignored and I end up getting null values.

How do I write the filter so that the parentheses will be included?

Thanks!
 

[Zubair_Muhammad · Accepted solution]

@Anonymous

It works with me 

See the attached file