Forum Discussion
arif_ali
Helper I
Helper ISub total in filter
Hello All, I have a count of units for a selected period. I am trying to count only those who have bought an average of 2 units i.e. total units bought 9 in 3 months so an average of 3. I want ...
// Dealers must be a dimension connected // to the fact table on DealerId. Active Dealers = VAR mStartDate = MIN( 'Business Dates'[Date] ) VAR mEndDate = MAX( 'Business Dates'[Date] ) VAR mMonths = DATEDIFF( mStartDate, mEndDate, MONTH) + 1 var __dealers = SUMX( Dealers, 1 * ( [Products CY] >= 2 * mMonths ) ) RETURN __dealersBest
D
