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 CONDITIO...
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!

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!

  • ss89's avatar
    ss89
    Helper II
    3 years ago

    Hi onurbmiguel_ ,

    thanks for your tips, it works!

     

    The last thing: items that meet the two conditions at the same time (RECEIVING=APPROVED & SAMPLING=ONLINE) should be displayed only the item that has SAMPLING=ONLINE otherwise I risk having duplicates in the display

     

    I would like to visualize only the lot_id with Sampling online.

     

    Thanks in advance!

     

    • onurbmiguel_'s avatar
      onurbmiguel_
      Power Participant
      3 years ago

      hi ss89 

       

      Try this one: 

      Total_1 = 
CALCULATE(
    Distintcount(Lot_ID),
    or(
        AND(Stage Name = "RECEIVING" , Condition = "APPROVED"),
        AND(Stage Name = "SAMPLING" , Condition = "ONLINE")
    )
)

       

      like this the total will be right 

       

      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

        Hi onurbmiguel_ ,

         

        the following error message appears:

         

        "Too many arguments passed to the DISTINCTCOUNT function. A maximum of 1 arguments are allowed"

         

      • onurbmiguel_'s avatar
        onurbmiguel_
        Power Participant
        3 years ago

        Hi ss89 

        Sorry the delay, please reply alway in the last message otherwise it will be difficult to see your feedback.

         

        some notes: 

        • in the the first message i told you to creat a measure not a calculated column 
        • in the erro that you show you need to close the parentheses in the distinct count 
        • to share a file you need to creat a share link in onedirve or goggle drive 

         

        i will wait for your feedback

         

         

        Best regards

        Bruno Costa | Impactful Individual