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

felipescamilo — Mon, 26 Dec 2022 18:12:51 GMT

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.

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

tamerj1 — Mon, 26 Dec 2022 18:23:15 GMT

Hi felipescamilo

please try

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

topic How do I calculate how many different products a store has sold in a month? in DAX Commands and Tips

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

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