Indirect Set Analysis

[Andy_C]

Hi

Im using the expression below to sum sales by AccountID for accounts that include the product ‘Prosecco’.  

sum({<[AccountID]=P({<[Product Name]={[Prosecco]}>})>}[Sales])

However I now want to expand this to only sum sales on accounts which have a 'Quantity Sold' of Prosecco of X, but im struggling to link sum([Quantity Sold]) for ‘Prosecco’ into the expression

Thanks in advance

Andy

[martinpohl]

here is an example of sum sales only for those customers who have sell an quantity > 1000

sum( {$<AccountID= {“=Sum({1<[Product Name] = {Prosecco}>} [Quantity Sold] ) > 1000”}>} Sales )

Regards

[Kushal_Chawda · Accepted solution]

try this

sum({<[AccountID]={"=sum({<[Product Name]={'Prosecco'}>}[Quantity Sold])=X"}>}[Sales])

Note: Replace X with actual number .You can also use '>' ,'<'

[Andy_C]

Thank you both for the quick responses, this expression appears to be returning the numbers i was expecting