Running Total is not working as expected

[Anonymous]

Hello Experts,

Need your help. The DAX for Cumulative total(Running Projected_Velocity) is not working for my last row.

Below are the DAX used :

Running Projected_Velocity = CALCULATE( [Projected_Velocity], FILTER(ALL('Issues'[Sprint]),Issues[Sprint] <= MAX('Issues'[Sprint])))

Projected_Velocity = IF (MAX ( 'Issues'[Sprint] ) >= VALUE ( [Sprint] ),[Velocity_Forecasting],[Actual Velocity])

Actual Velocity = CALCULATE (COUNT ( Issues[Issue Key] ),FILTER ( Issues, Issues[Issue Type] = "Epic" ))

It is not adding up the total sum of "Actual velocity"( Cumulative Total) with "Velocity_Forecasting".

Is it because "Actual Velocity" and "Velocity_Forecasting" are 2 different measures??

Note: "Velocity_Forecasting" is a measure which is the average of my last 6 sprints.It is the projected velocity for future sprints.Now my active sprint is 250. 397 epics is the average of my last 6 sprints.So for my future sprint ,397 is projected Epics count .

Expected Result:

Thanks In Advance

[v-yingjl]

Hi @Anonymous ,

Based on your descritption, the expected output is clear but what did 'Projected_Velocity = IF (MAX ( 'Issues'[Sprint] ) >= VALUE ( [Sprint] ),[Velocity_Forecasting],[Actual Velocity]) '  calculate? 

The Cumulative total [Running Projected_Velocity] seems like no problem and the [Actual Velocity ] measure calculates some specific value.

Could you please consider sharing more details about [Projected_Velocity] measure or sharing a sample .pbix file without sesentive information for further discussion?

Sample fiile would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , what are you try here in bold

Projected_Velocity =

IF (MAX ( 'Issues'[Sprint] ) >= VALUE ( [Sprint] ),
[Velocity_Forecasting],
[Actual Velocity]
)

Try

Projected_Velocity =Sumx(VALUE ( [Sprint] ),

IF (MAX ( 'Issues'[Sprint] ) >= VALUE ( [Sprint] ),
[Velocity_Forecasting],
[Actual Velocity]
))

Appreciate your Kudos!!