Forum Discussion
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
Community 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
Community 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
Responsive 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
Community Champion
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