Forum Discussion

ss89's avatar
ss89
Helper II
3 years ago
Solved

double filter with unique matching

Hello Community,

 

I need to filter in a visual object all the elements that have contemporarily these two conditions:

STAGE NAME: RECEIVING
CONDITION: APPROVED

&

STAGE NAME: SAMPLING
CONDITION: ONLINE

If I select the filter by stage name and by condition it filters everything that has receing approved and online and sampling approved and online instead I would like to display only the items that have receiving approved and sampling online.
Can someone kindly help me?

Thanks in advance!

Need Help
  • onurbmiguel_'s avatar
    onurbmiguel_
    3 years ago

    Hi ss89 

    On the table that you have on the question add the measure to only see the cases where the condition is valid. 
    Or you can add the measure as a filter in the visual and select "is greater than" 0.

     

     

    Best regards

    Bruno Costa | Impactful Individual

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍


    You can also check out BI4ALL's website and our data solutions!

10 Replies

  • onurbmiguel_'s avatar
    onurbmiguel_
    Power Participant
    3 years ago

    Hello ss89 

     

    My suggestion is that you create a measure that show the number os rows in the first or second condition. 

    Something like this: 

    Total_1 = 
CALCULATE(
    COUNTROWS('factTable'),
    or(
        AND(Stage Name = "RECEIVING" , Condition = "APPROVED"),
        AND(Stage Name = "SAMPLING" , Condition = "ONLINE")
    )
)

     

    If you need more help please sahre a pbix with some dummy values. 

     

     

    Best regards

    Bruno Costa | Impactful Individual

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

    You can also check out BI4ALL's website and our data solutions!

     

    • ss89's avatar
      ss89
      Helper II
      3 years ago

      Hello,

       

      thanks for your propomt reply!

       

      In this way, however, I get a total as a result; I would instead need to have only the list of all the activities that have these combined filters.

       

      Thanks in advance!

      • onurbmiguel_'s avatar
        onurbmiguel_
        Power Participant
        3 years ago

        Hi ss89 

        On the table that you have on the question add the measure to only see the cases where the condition is valid. 
        Or you can add the measure as a filter in the visual and select "is greater than" 0.

         

         

        Best regards

        Bruno Costa | Impactful Individual

         

        Hope this answer solves your problem!
        If you need any additional help please @ me in your reply.
        If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍


        You can also check out BI4ALL's website and our data solutions!