How do I calculate how many different products a store has sold in a month?

[felipescamilo]

Hi! I'm having trouble calculating how many different products a store has bought in a month. I'm currently using the following formula as in an example for august:

CALCULATE(
(DISTINCTCOUNT(Product[Product Code),
FILTER([Product], [#Sales]>0),
Date[Month/Year]="aug/2022")

 
It returns me how many different products the store has sold, but it is not considering in august. The number is always the same for every month i pick.

[tamerj1 · Accepted solution]

Hi @felipescamilo 

please try

=
COUNTROWS (
CALCULATETABLE (
VALUES ( 'Product'[Product Code] ),
CROSSFILTER ( 'Product'[Product Code], 'Sales'[Product Code], BOTH )
)
)