Incorrect data represented when using multiple date tables and filters

[Anonymous]

Hello, 

My PowerBI dashboard is to represent the number of submissions that an assigned tech is either in a CLOSED or OPEN state. this report is based on a single table with both Created and Closed Dates and within the Report View is filtered in conjunction with using a slicer of the status of the case either OPEN or CLOSED. 

In the linked file, I have  created a non aligned datetable and then created seperate relationships with a CLOSED Datetable and OPEN Datetable that are linked to the CREATED and CLOSED date fields in the VariableData table which has the information. 

My issue is that I am unable to get the correct number of records that are in the dataview. 

For example if I choose Name "Courtney Lin" from the name slicer and choose the month of April (4/1/2023-4/30/2023), in the report view table 2 records are shown as if it's being filtered by the Created_DTE. However;  when looking at the raw data in the DataView using the same parameters using the Closed_DTE, I see that there are 9 records. 

If there's anyone who can help with this I'd really appreciate it or at least provide some suggestions.

Power BI Example File 

PowerBI Data 

[lbendlin]

I have  created a non aligned datetable and then created seperate relationships with a CLOSED Datetable and OPEN Datetable that are linked to the CREATED and CLOSED date fields in the VariableData table which has the information. 

That is not a recommended approach.  Have a single dates table, connect it to the Open Date with an active relationship and to the Close Date with an inactive relationship.  Then create your measures , using USERELATIONSHIP  for the close measure.

[Anonymous]

Ok, I'm fairly new to the USERELATIONSHIP dax coding. how would I go about doing this?