Countrow crossjoin

[pser]

Hi,

After using several hours now on trying to solve a dax formula, I now try to post my challenge here. I am new to DAX and trying hard to get around. I have three dimension: Fact, StartDate and EndDate. I want to count number of occurence of field 'fact'[Product] where the field 'fact'[Product created date] is between 'StartDate'[date] and 'EndDate'[date].

My initial thought was
Number of product:=CALCULATE(COUNTROWS('fact'[Product]),FILTER('Fact','StartDate'[Date]>'Fakta'[Product Created Date] && '****tDato'[Date]<'Fakta'[Product Created Date]))

I believe my challenge is the filer where I am trying to filter a dimension using a field from two other dimension, so I need some cross join. I know it is odd having two date dimension, but that is the reality I have to work with.

Any suggestion on next move would be appreciated

 

[pser]

I see I have some typing error in the formula, correct formula is: Number of product:=CALCULATE(COUNTROWS('fact'[Product]),FILTER('Fact','StartDate'[Date]>'Fakta'[Product Created Date] && 'EndDate'[Date]<'Fact'[Product Created Date]))