Forum Discussion

ChristianPower's avatar
ChristianPower
New Member
4 years ago

Running Sum

Hello,

 

I am pretty desperated. Can someone please tell me how I get the accumulated sum of the columns "PercentageOfTotal" here? (see picture) I tried everything 6hours but nothing is working.  Also tried quick measure calculated sum, but it did just gave me the same column - no runnuing sum.

 

I am even thinking that something with Power BI is not working.

 

 
 

 

 

4 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion

    Hi ChristianPower , here is pic


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion

    Hi ChristianPower , Try this

    RT =
    VAR _getRang =
        MAX ( myTable[Rang] )
    VAR _calc =
        CALCULATE (
            SUM ( myTable[PofTotal col] ),
            FILTER ( ALL ( myTable ), myTable[Rang] <= _getRang )
        )
    RETURN
        _calc
    


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

  • ahmedoye's avatar
    ahmedoye
    Icon for Responsive Resident rankResponsive Resident

    Hi, you have missed out FILTER function.

     

    Try write something like: 
    CALCULATE(SUM(Spend Tail Analysis[PercentageOfTotal],
    FILTER(ALL(Spend Tail Analysis), Spend Tail Analysis[Rang] <= MAX(Spend Tail Analysis[Rang]))

     

    If this solution works for you, please mark it as solution to allow other searching members easily find solutions.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion

    Hi ChristianPower 

    Here is something close

    running total in Date =
    CALCULATE(
    [Sales Amount],
    FILTER(
    ALLSELECTED('Calendar'[Date]),
    ISONORAFTER('Calendar'[Date], MAX('Calendar'[Date]), DESC)
    )
    )

     

    Replace [Sales Amount] by your "Percentage of totalt" and "'Calendar'[Date]" by your Rank column