Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cumulative Totals Not Working Correctly

I'm seeing some odd behavior when trying to calculate the cumulative totals of activities completed in a project schedule.  I have two relationships between the data table and the date table, an acti...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

That one didn't work either.  The cumulatives still add up to less than the sum of the AB quantity.

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

Have you used" SUMX(AP,[As-Built Activity Count] " in measures, please add and try it again.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Amy,

     

    Right now I'm using this:

     

    AP Cumulative Qty = CALCULATE(SUMX(AP,[As-Planned Activity Count]),FILTER(ALLSELECTED('Date Table'[Date]),'Date Table'[Date] <= MAX('Date Table'[Date])))
     
    and 
     
    AB Cumulative Qty = CALCULATE(SUMX(AP,[As-Built Activity Count]),USERELATIONSHIP(AP[AB Finish],'Date Table'[Date]),FILTER(ALLSELECTED('Date Table'[Date]),'Date Table'[Date] <= MAX('Date Table'[Date])))
     
    This still results in a weird result as shown above (that set of unexpected 8's in the AP Cumulative Qty and the incorrect totals in the AB Cumulative Qty.