Running total is not calculated correctly

[amirghaderi]

Any idea why the below Planned **bleep**% running total is not calculated correctly?

"Normalized Weighted Progress (Planned)" is a measure

Cut-ff is a date from a date table which has one to many relationship with the Planned **bleep** % table

[amirghaderi]

I was hoping to get something to the below:. I have done a bit of concept change in the data complitaion and got that worked now.

[Dhairya]

Hey @amirghaderi 
Please try the following measure

Planned cumulative % = 
VAR MaxDate = MAX('Cut-Off'[Cut-Off])
RETURN
      CALCULATE(
               [Normalised Weighted Progress (Planned)], 
               'Cut-Off'[Cut-Off] <= MaxDate,
               ALL (Cut-Off)
       )

Please Mark my solution as accepted if it helped you!

[amirghaderi]

Still the same issue. I have shared the file in the below link

https://www.dropbox.com/s/de9kr3988sjbitl/Overall%20S-Curve%20-%20to%20share.pbix?dl=0

[v-zhangti · Accepted solution]

Hi, @amirghaderi 

You can try the following methods.

Normalized Weighted Progress (Planned) = sum(Planned[Weighted Progress (Planned)])/CALCULATE(sum(Planned[Weighted Progress (Planned)]),ALL(Planned))

No other formulae need to be changed.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[amirghaderi]

Thanks for your response. But, your measure does not show the cumulative value over the time scale similiar to running total

[v-zhangti]

Hi, @amirghaderi 

And what kind of outcome do you expect?

Best Regards