Visual advanced Filter does not work

[IlMoro]

Hi,

I have a column with differen phrases and I just wanted to count them and filter out few of those but is seems that advance filter does not work.

Just changing the second parameter from "contains" to "does not contains" all data reset and none is filtered out even if the first parameter is in place (4005 is the total number of lines).

The word "hrtjhsjntntrnstrns" does not exist in the souce file and I inserted it just as test to figure out if there was a bug in the program.

PowerBI desktop version 2.98.683.0 64-bit (oktober 2021).

Any useful help is appreciated.

[amitchandak]

@IlMoro , I think conditions should be and in both case

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[IlMoro]

If I set "AND" then I've got "0" (zero) data, empty graph, as I would expect so in this case the filter works.

It is with the option "OR" that the filter does not work.

All the data is sensitive however I will try (give me just a while) to do a screenshot and remove everything except those items that can provide some useful information for the case resolution.

[IlMoro]

This is the table so very simple.

If I add, as second option, "do not contains" and "password" then I get the filter reset and it shows all 4005 objects in the graph.

[Anonymous]

Hi @IlMoro 

Is your issue that when you use "does not contain" twice with OR logic in filter, the result will return to 4005(all objects)?  I think this correct, "or" means not including A or not including B. So the result will be count of not including A + count of not including B <=Total(4005). In your screenshot, the second word "hj..." is a word not contain in each row. So this will cause count of not including "hj..." return 4005. 

My Sample:

Result:

Best Regards,
Rico Zhou

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

[IlMoro]

Hi @Anonymous 

I would expect what you've got from your exempel if i used the condition "And" since "And" is a "+", not "Or".

"Or" means that the filter has to consider one OR the other, not both at the same time.

"And" means that the filter has to respect both conditions at the same time.

So it seems that the filter is not working as it should...