Visual advanced Filter does not work

Question

Hi,&nbsp;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.&nbsp;Just changing the second parameter from "contains" to&nbsp;"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).&nbsp;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.&nbsp;PowerBI desktop version&nbsp;2.98.683.0 64-bit (oktober 2021).&nbsp;Any useful help is appreciated.&nbsp;

ilmoro · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;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.&nbsp;So it seems that the filter is not working as it should...

amitchandak · Answer

IlMoro , I think conditions should be and in both case
&nbsp;
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
&nbsp;
&nbsp;

ilmoro · Answer

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 · Answer

This is the table so very simple.&nbsp;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.&nbsp;&nbsp;&nbsp;

anonymous · Answer

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

Result:

Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Visual advanced Filter does not work

5 Replies

Related content

Advanced filters

Advanced Filter

Advanced Filter

Advanced visualization

Date filters for Visualization