Forum Discussion

amirghaderi's avatar
amirghaderi
Helper IV
3 years ago
Solved

Running total is not calculated correctly

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 r...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

     

     

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

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's avatar
    amirghaderi
    Helper IV
    3 years ago

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

    • v-zhangti's avatar
      v-zhangti
      Community Support
      3 years ago

      Hi, amirghaderi 

       

      And what kind of outcome do you expect?

       

      Best Regards