Show accounts that have two products

[Anonymous]

Shouldn't this work to show all account numbers that have both '1027073" and 'C#XIO' - and is there an easier way? =count({}[Account Movex Number])>*}DISTINCT[Account Movex Number])

[Anonymous]

=count({}[Account Movex Number])>*}DISTINCT[Account Movex Number])

[phaneendra_kunc · Accepted solution]

Try this.. if you want to get Accounts that has TWO products. AND operator.

Count({<Account=P({<Product={'1027073'}>})*P({<Product={'C#XIO'}>}),Product={'1027073','C#XIO'}>} Distinct [Account Movex Number])

Adjust Account and Product fields according to your datamodel.

[Anonymous]

Excellent!  Thank you so much Phaneendra.