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...
  • 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💪