Identify Sales With a Specific Item in PowerPivot

[eliwaite]

I have a table with sales of individual products, along with their sales order ID. I want to add a calculated column that will indicate if a certain product was contained in the sale. It might be easier to give an example. In this example I want a calculated column that will indicate if the sale included an apple.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sales ID[/TD]
[TD]Product[/TD]
[TD]Calculated Column Desired Output[/TD]
[/TR]
[TR]
[TD]10859
[/TD]
[TD]Apple[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]10655[/TD]
[TD]Orange[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]10655[/TD]
[TD]Strawberry[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]16549[/TD]
[TD]Strawberry[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]16549[/TD]
[TD]Apple[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

I need a formula that say something like, look for related Sales ID, do any of them contain an Apple, if so Yes, if not No.

Any ideas? Thank you.

 

[PowerDAX]

So sorry! I started with a calculated field and tried to retrofit it to a column and was not paying enough attention.

This one works as expected:

=CALCULATE(
COUNTROWS( SalesOrders ),
CALCULATETABLE(
SUMMARIZE(
SalesOrders,
SalesOrders[Sales ID]
),
ALL ( Products), SalesOrders[Product]="Apple"
)
)