COUNTIF for Duplicate Dates = VAR __CurrentRowID = Sales[Date] RETURN COUNTROWS( FILTER( ALL(Sales), __CurrentRowID = Sales[Date] ) )