SELECT statement with multiple criteria?

[SpaceCoyote]

Hello,

I’m trying to create an initial value from a table that uses multiple criteria.

Table example (Sales):
Customer | Promo | Available Qty
Steve | Apple | 2
Steve | Pear | 3

Something like SELECT(Sales[Available Qty], [Customer] = [_THISROW].[Customer], [Promo] = [_THISROW].[Promo]))

So, it would create a single initial numerical value of 2 for Steve if the promo was Apple, and 3 if the promo was Pear

It doesn’t seem to work that way, and I also tried using nested SELECT statements. Any ideas?

Thanks,

Chris