COUNTAX with filter criteria and DISTINCTCOUNT

[IinCircle]

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Store
[/TD]
[TD]Product
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]Orange
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]Pear
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]Orange
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]Orange
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]Pear
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]Apple
[/TD]
[/TR]
</tbody>[/TABLE]
Hi, I tried to have a formula combining COUNTAX and DISTINCTCOUNT but keeps getting an error message.

I want to count the number of Stores that sold Apple, which in this case is 3.
=CONTAX(FILTER(Table,[Product]="Apple",[Product])AND(DISTINCTCOUNT(Store))

 

[IinCircle]

Another formula I tired:
=ALATE((DISTINCTCOUNT(STORE),(FILTER(TABLE,[PRODUCT]="APPLE"))

 

[scottsen]

That 2nd attempt looks good, if you fix up your syntax:

=CALCULATE(DISTINCTCOUNT(Table1[Store]), FILTER(Table1, Table1[Product] = "Apple"))