DAX measure to Sum if all category values exist

[RustyNails]

I have two categories: Apples and Oranges. I want to Sum the product's Qty if and only if BOTH apples and oranges have a Qty count for that particular product. Here's an example

In the example above, only Item 1 and Item 4 have both Apples and Oranges Qty so they are the only valid ones that I want to count. I want to exclude Item 2 and 3 because they have one category each (and not both).

How do I even begin with the DAX here? To take a step further, the Category field is dynamic. I could have Apples, Oranges and Bananas and items should have all three Qty's to satisfy my criteria. Any help is greatly appreciated.

[Zubair_Muhammad]

@RustyNails

try this measure

Measure =
VAR AllCat =
    COUNTROWS ( ALL ( Table1[Category] ) )
RETURN
    CALCULATE (
        SUM ( Table1[Qty] ),
        FILTER (
            VALUES ( Table1[Product] ),
            CALCULATE ( COUNTROWS ( VALUES ( Table1[Category] ) ) ) = Allcat
        )
    )

[Zubair_Muhammad · Accepted solution]

@RustyNails

Please see attached file as well