Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Advance Filter

I have 2 columns, and I need an intelligent filter that can select types only when a condition is met.

Color       Type
Blue         A,B
Brown     A,D
Red         C,B
Yellow     A,B,C



The model that I have was splitted in this way:

Color      Type
Blue        A
Blue        B  
Brown     A
Brown     D  
Red         C 
Red         B  
Yellow     A
Yellow     B  
Yellow     C  

If I select A, C, D, the result should be:


Color     Type
Brown     A,D

But my result using a Slicer is
Color   Type
Blue       A,B
Brown    A,D
Red        C,B
Yellow    A,B,C

Could you please help me to find a solution?

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    I change something in my sample, you could try to use measure 8 for your sample(or you could use measure 6), and manually change table 3(beacuse it sort wrong when use values (table)). You could refer to my sample for details.

     

    Best Regards,
    Zoe Zhi

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

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    Incredible solution, thanks💪

4 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Anonymous , 

    You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Color       Type
      Blue         A,B
      Brown     A,D
      Red         C,B
      Yellow     A,B,C

       

      Hi Zoe,

       

      Thanks for the help, I really appreciate it. I checked the pbxi and is really impressive. I have a question, what happen if I have to select a different combination, for example:  If I have to select B,C? The results should be:

      Red         C,B
      Yellow     A,B,C

       

      If I have to select A, B? The results should be:

      Blue         A,B

      Yellow     A,B,C

       

       

      That is the result that I need.

       

      Thanks for the help,

       

      Arthur

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi Anonymous , 

        I change something in my sample, you could try to use measure 8 for your sample(or you could use measure 6), and manually change table 3(beacuse it sort wrong when use values (table)). You could refer to my sample for details.

         

        Best Regards,
        Zoe Zhi

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