Help totaling measure correctly

Question

I am very inexperienced with Dax and am needing help with a measure.&nbsp; The measure works correctly by row, but does not total correctly.&nbsp; I understand why it doesn't total correctly, but haven't been able to modify it to total correctly.&nbsp; Any help would be greatly appreciated.&nbsp; I have attempted this in a calculated column, but get the wrong answer.&nbsp; 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.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DaysToComplete = CALCULATE(Sum(FiscalDate[IsWorkday]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATESBETWEEN((FiscalDate[Date]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Minx(ForecastTbl,ForecastTbl[StartedDate]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Minx(ForecastTbl,ForecastTbl[EndDate])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;))&nbsp;Thank you for your help.&nbsp;&nbsp;

anonymous · Answer

We need to see:&nbsp;1. The model.2. Some sample data.3. Some correct results.&nbsp;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.&nbsp;BestDarek

nandvroe · Answer

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

anonymous · Answer

Good.&nbsp;BestDarek

Forum Discussion

Help totaling measure correctly

3 Replies

Related content

Total % not showing correctly

% of total measure

Total of Measure

Measure totals not summing correctly

Measure Total Incorrect