Forum Discussion

IlMoro's avatar
IlMoro
Icon for Helper II rankHelper II
4 years ago

Visual advanced Filter does not work

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 "...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    IlMoro
    Icon for Helper II rankHelper II
    4 years ago

    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's avatar
      IlMoro
      Icon for Helper II rankHelper II
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

        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.