Advance Filter

[Anonymous]

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?

[dax · Accepted solution]

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.

[dax]

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]

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 · Accepted solution]

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 · Accepted solution]

Incredible solution, thanks💪