Expression to count distinct stores for multiple condition

[ms_12]

Hi All,

I have below dataset. I want to find the distinct count of store where Type ='Local' and Sub Type='Apples' & 'Pears'. I this case distinct count will be 2 (Store 'A' & 'D'). I need set analysis expression to achieve the same.

Store	Type	Sub Type
A	Local	Apples
A	Local	Pears
A	Export	Bananas
A	Export	Pineapples
B	Local	Apples
B	Export	Pears
B	Export	Coconuts
C	Local	Grapes
C	Export	Apples
C	Export	Pears
D	Local	Apples
D	Local	Pears
D	Local	Grapes
D	Export	Pineapples

[Kushal_Chawda · Accepted solution]

@ms_12  try below

=count(distinct {<Store=p({<Type={'Local'},[Sub Type]={'Apples'}>})*p({<Type={'Local'},[Sub Type]={'Pears'}>})>} Store)