Count returning less results when using Date Table

[Anonymous]

Hi there, 
Currently working on a project for work which contains multiple DateTime columns. 
I'm having an issue when using a calendar table, where the incorrect value is returned compared to when using a date column outside the calendar table. 
DAX Measure. 

Tasks Count = (COUNT(FM_Task_Detail[Task Sequence]))

The model:

 
I have added bi directional relationships to allow filter propogation from ResourceTeams through to TaskDetail and Task Performance.

Below is an example of the incorrect count.

 Below is an example of the expected result. In this example I'm using the Task Reported Date which resides in the Task Detail table with Task Sequence which I am counting. 

Any ideas on what is causing rows to be ommitted from the filter context? Rather confused. 

Unable to provide sample data unfortunately.


Thanks,
Ross

[Anonymous · Accepted solution]

I have found a solution. 
In this instance, I created an  inactive relationship between Task Detail and Dates. 

From there I added Calculate with USERELATIONSHIP to enforce the correct date filter context. 

Thanks,
Ross

[Greg_Deckler]

What are the relationships between those three tables? Dates, Task_Detail and Time_Records. It would appear that for some reason the relationship between Dates and Time_Records is filtering out certain tasks in Task_Detail.

[Anonymous]

So, One Task Sequence in Task Detail can have Many related rows in Time Records. 
For example. Task Sequence 1 could have Time Record Sequences 1,2 and 3. 

In short, many time record sequence numbers can be related to a single Task Sequence number.

The relationship between Time Records and the date table is based on DateKey. Duplicated from 'Time Record Started' formatted to Date rather than date time. This connects to the FullDate in the Dates table. 

Thanks,
Ross

[Anonymous]

@Greg_Deckler It's also worth noting that there are multiple date columns. Task Reported Date and Time Record Started Date could have dates which are different. (An engineer task which takes multiple visits for example) 

[Greg_Deckler]

@Anonymous - Right and the multiple date columns are likely where some of the issues like. What dates or other colums are Task_Details and Time_Records related on?