Forum Discussion
Running total is not calculated correctly
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.
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!
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
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.
Thanks for your response. But, your measure does not show the cumulative value over the time scale similiar to running total
