Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Three Criterions on Filters

Hello everyone,

 

I found that here we can maximum have just 2 criterion, can we have more than 3?

 

Thanks in advance,

 

Best regards,

Hanson

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi you could create a custom column that if the CustomerGroup contains Type A or Type B or Type C, mark them as "Y", others mark as “N”. Then filter this custom column. Thanks!

9 Replies

  • Anonymous 

    You can create a measure and drop here on the Visual Filter.

    Please share your conditions with sample data if you need help building a measure.



    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Fowmy,

       

      Sorry can't share data, just make up a simple case, if I want a filter of CustomerGroup contains 'Type A' or 'Type B' or 'Type C', what should the measure looks like?

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi you could create a custom column that if the CustomerGroup contains Type A or Type B or Type C, mark them as "Y", others mark as “N”. Then filter this custom column. Thanks!