Running Sum

[ChristianPower]

 

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.

[Nathaniel_C]

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

[aj1973]

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

[ahmedoye]

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.

[Nathaniel_C]

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