Deconnect relationship?

Question

I am trying to calculate the count of active tasks in selected period, but I don't know how I should treat the relationships between the tables.&nbsp;The table 'Task' is connected to 'DimDate' by start date, and when I count the active tasks this realtionships seems to mess it up since I only get the task with startdate = MIN(DimDate) selected.&nbsp;Measure looks like this:# Tasks = &nbsp; &nbsp; VAR mxdt = MAX(dimDate[Date])&nbsp; &nbsp; VAR mndt = MIN(dimDate[Date])&nbsp; &nbsp; VAR &nbsp;CALC = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DISTINCTCOUNT(Task[Task ID])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , FILTER(ALL(Task[End Date],Task[Start Date])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , (Task[End Date] &lt;= mxdt &amp;&amp; Task[End Date] &gt;= mndt)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || (Task[Start Date] &gt;= mndt &amp;&amp; Task[Start Date] &lt;= mxdt &amp;&amp; Task[End Date] &gt;= mxdt)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || (Task[Start Date] &lt;= mndt &amp;&amp; Task[End Date] &gt;= mxdt)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; RETURN&nbsp; &nbsp; CALC&nbsp;I want to count all ongoing tasks, so if I select one day (eg 05.10.2022) I will list all ongoing tasks, not only the one starting on 05.10.2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

bmpi , refer to the attached file after signature&nbsp; 
&nbsp;

Forum Discussion

Deconnect relationship?

1 Reply

Related content

Relationship

Relationships

Relationship Issue

Creating relationships

PowerBI Relationships