Measure to identify based on criteria

[one3nine0]

I have a table in powerpivot showing invoices, and two calculated columns to identify Product A (1) or Product B (2)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Invoice[/TD]
[TD]Product[/TD]
[TD]Units[/TD]
[TD]Price[/TD]
[TD]Calculated Column 1[/TD]
[TD]Calculated Column 2[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]A[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]True[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]B[/TD]
[TD]1[/TD]
[TD]50[/TD]
[TD]False[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]C[/TD]
[TD]1
[/TD]
[TD]100[/TD]
[TD]False[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]A[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]True[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]D[/TD]
[TD]1[/TD]
[TD]25[/TD]
[TD]False[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]B[/TD]
[TD]1[/TD]
[TD]50[/TD]
[TD]False[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]A[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]True[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]C[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]False[/TD]
[TD]False[/TD]
[/TR]
</tbody>[/TABLE]

I want to be able to write a measure that will identify if each invoice has both "True" in calculated columns 1 and 2.

That way when I pivot it out, I can see the invoice number, products bought, total spend, and if a true/false if the invoice has both products A and B.

Any Suggestions?

 

[gazpage]

=IF(
    CONTAINS (
        Table, 
        Table[Product],
        "A"
    ) &&
    CONTAINS (
        Table, 
        Table[Product],
        "B"
    ),
    "Yes",
    "No"
)

 

[one3nine0]

Thanks this works exactly how I asked!

I unfortunately now know I forgot to include details to my question because it did not work they way I wanted.

So the measure works perfectly if I pivot based on invoice number.

The problem, is that I need to get down to the products bought as well. But if I add products to the pivot table, the "Criteria" measure shows No for everything.

Is there a way to include products to the table, but the criteria only answer on the invoice level?

 

[gazpage]

Wrap the previous measure in a CALCULATE with second parameter as an ALLEXCEPT on Invoice.

 

[one3nine0]

Sorry I took so long to reply, this works perfectly!