Cumualitve Total Per Team and Priority

[bcobrien1977]

Hi,

 I am trying to create a simple table that shows a running total and running percent total  per priority and team that will look something like this.

RunningTotal =

CALCULATE (

    SUM ( 'ITERATION DATA'[Total Capacity] ),

    ALLEXCEPT ( 'ITERATION DATA', 'ITERATION DATA'[TeamCodeName] ),

  'ITERATION DATA'[Index] <= ('ITERATION DATA'[Index])

)

When I use this measure, it will not display the previous total if things have not changed.  How do I get this so it will always show the previous total if there is not a new incremental amount?  Thanks

[Greg_Deckler · Accepted solution]

@bcobrien1977 It's all one table so CALCULATE won't work. Use a No CALCULATE approach instead.

[Greg_Deckler · Accepted solution]

@bcobrien1977 It's all one table so CALCULATE won't work. Use a No CALCULATE approach instead.

[bcobrien1977 · Accepted solution]

Hi,

I had a bunch of things leap frog this and I am coming back to this and this still doesn't work.  If I understand correctly, you should be able to use something other than a date and this will still work.  

I am using this as a measure.

TEST Total =

VAR _MAX_PRIOR=max('Priority Intiative'[Priority - Copy])

VAR _TABLE=FILTER(ALLSELECTED(' CAPACITY'),' CAPACITY'[Priority - NUMBER]<= _MAX_PRIOR)

RETURN  

SUMX(' CAPACITY',[MAX STORY POINT ESTIMATE ALLOCATED]

)

When I use this formula, it still does not create a cumulative total.  In the first column, I would expect 394 to carry down untill adds the 68 and then that 458 would carry down to the bottom.  Can you please take a look? Thanks