Forum Discussion

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_
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!

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!