Measure using date range skips over dates

Hey Anonymous ,

I'm wondering if the tables 'Combined' and 'DatesLink' are related, and if this is the case what is this relationship? My assumption: the relationship is between the columns 'DatesLink'[Date] (on the one side) and 'Combined'[CreatedDate].

Maybe you might consider to check the option "Show items with no data" for the column 'DatesLink'[Date] that you are using in the table visual, the next screenshot shows how to check/uncheck this option:

I'm also wondering, why you are using the function FILTERS, from my understanding of the formula you provided I would use VALUES instead, even if both would return the same "table", as 'DatesLink'[Date] is used on the rows.
I would rewrite the measure like so (no idea if this solves the issue with skipped dates), but at least it chaches TODAY into a variable.

Sev3 =
	var _today = [today]
	return
	SUMX(
	'Combined'  
	, COUNTX( 
		VALUES( 'DatesLink'[Date] )
		, IF(
			AND(
				AND(
					AND( [Date] >= Combined[CreatedDate] ,  [Date] <= _today ) 
					, OR ( Combined[CompletedDate]=BLANK() ,  [Date] < Combined[ClosedDate] )
				)
				, Combined[Severity] = "3 - Medium"
			)
			, 1, BLANK() 
			) 
		) 
	)

Maybe the reason why dates are "skipped" if the measure is applied is simply this: it returns BLANK() for the dates from 2016 and 2017, as the bugs created in 2016 are no longer open (hopefully) 🙂

Regards,

Tom