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.

Sales ID	Product	Calculated Column Desired Output
10859	Apple	Yes
10655	Orange	No
10655	Strawberry	No
16549	Strawberry	Yes
16549	Apple	Yes

<tbody>
</tbody>

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"
)
)