Forum Discussion
Visual advanced Filter does not work
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.
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.
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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...