Ignoring Relationships

Hi,

Having a bit of difficulty nailing down a formula and hoping for some help.

I have three tables in a relationship:

Case - Represents a case of work

Report - Represents reports associate with cases

Date - Date Dim

I'm trying to show how many reports have been completed on each closed case and continually falling short.

My data looks like the below; Date is a standard date dimension with multiple columns i.e. Date and MonthYear (MMM-YY). Case links to Report and Date with active relationships; Report links to date with inactive relationships.

Case

Report

According to the above, I know that 2 cases closed in Jan-19; I can prove this with

CasesCount = DISTINCTCOUNT('Case'[ID])
closedCases = CALCULATE([CasesCount], ISBLANK('Case'[OpenCase]))

I then want to find the number of reports associated with that case; I don't care when they were completed, I just need to know that they exist on that specific case.

When I look at the case level I get the right answer but once a date value is brought in, the figures are wrong and I'm shown closed cases (correct) but reports filed in that period (incorrect), my question is how can I ignore any date relationships with Reports and show a count of reports for all cases closed in that period.

I would expect to see something like the below but instead I'm seeing 3 reports because one of those was completed in a different month.

Most recently I've tried this but returning blank; I'm trying to say return the count of reports for any cases that closed during the time period.

start = MIN(Dates[Date])
end = MAX(Dates[Date])
reports = DISTINCTCOUNT(Reports[ID])
closedCasesReports = CALCULATE([reports],
			FILTER('Case', 
				'Case'[ClosureDate] >= [start] && 'Case'[ClosureDate] <= [end]
			)
		)

I've tried quite a lot of iterations with varying success but it appears that whenever the date is brought into the equation results return incorrectly... Can I ignore a date relationship altogether?

Any help greatly appreciated.