DAX: BUG? COUNT HOW MANY PRODUCTS I HAVE THRU ORDERS[DATE], EVEN WITHOUT SALES

[lprbi]

Hi,

Using PowerBI I having a big trouble with a task that seems simple: I need giving accross time (ORDER[DATE]), count how many products I have inserted in my database, even with no sales. I have a column for that: PRODUCTS[DT_INSERT]. Tried some, this give a correct value in the first YEAR, and wrong in th others:

CALCULATE(
COUNT(PRODUCTS[PROD_ID]);
CROSSFILTER(PRODUCTS[PROD_ID];ORDER_ITENS[PROD_ID];None);
FILTER(VALUES(PRODUCTS[DT_INSERT]);DATEVALUE(PRODUCTS[DT_INSERT])<=DATEVALUE(ENDOFMONTH(LASTDATE(ORDERS[ORDER_DATE]))))
)

Using DATEVALUE or not have no effect.

The total should give 2169 in 2015.

Please help

[lprbi]

I succesfully counted. Importing the table PRODUCTS twice (without any relationships)...

Tried crossfilter all relations on PRODUCTS no luck.

[TaylorClark · Accepted solution]

Count of products all-time: (probably equal to the number of rows in the Products table)

COUNTROWS(ALL(Products[ProductId]))

Running count of products, assuming there's a column that says the date it was added

    CALCULATE(

        COUNTROWS(VALUES(Products[ProductId])),

        ALL(Products),

        FILTER(ALL(Products), Products[AddedDate]<=MAX(Dates[Date])))