Forum Discussion

amirghaderi's avatar
amirghaderi
Icon for Helper IV rankHelper 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 relationship with the Planned **bleep** % table

 

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.

     

     

6 Replies

  • amirghaderi's avatar
    amirghaderi
    Icon for Helper IV rankHelper IV
    3 years ago

    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's avatar
    Dhairya
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    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!