Help totaling measure correctly

[nandvroe]

I am very inexperienced with Dax and am needing help with a measure.  The measure works correctly by row, but does not total correctly.  I understand why it doesn't total correctly, but haven't been able to modify it to total correctly.  Any help would be greatly appreciated.  I have attempted this in a calculated column, but get the wrong answer.  I believe the reason is that one "ProdNumber" can have several lines all started and ended on the same day, however each line is counted as a day and then it sums as several days instead of just one day. Below is my Dax Measure.

         DaysToComplete = CALCULATE(Sum(FiscalDate[IsWorkday]),

                  DATESBETWEEN((FiscalDate[Date]),

                  Minx(ForecastTbl,ForecastTbl[StartedDate]),

                  Minx(ForecastTbl,ForecastTbl[EndDate])

           ))

Thank you for your help.

[Anonymous]

We need to see:

1. The model.

2. Some sample data.

3. Some correct results.

You can do it all by pasting pics in here and descriptions in plain English. Always remember that it's you who knows the data and what you want to achieve. We don't.

Best

Darek

[nandvroe]

Thank you for your response.
I was actually able to get my calculated column working as expected so I will not need the measure.  

[Anonymous]

Good.

Best

Darek