Trying to create a cumulative total for people onboard a bus between bus stops

[Anonymous]

Hi!
As the subjectline foretells i am trying to create a culumative total.

I am trying to create a measure or a calculated column that takes totalInBalance and totalOutBalance into consideration.
So the new measure/column to the far right of the table should be:
12 on row 1,
11 on row 2,
9 on row 3
and so on

Any help would be much obliged!

Kind Regards
/D

[HiraNegi · Accepted solution]

Hi,

You can create measures/columns to calculate the running sum of InBalance and OutBalance and subtract to get the final result.

Here is the final screenshot with sample data.

Below measures were created.

Note: you can incorporate all measures into one as well.

InBlanace(RTotal) = CALCULATE(sum('Table (2)'[InBalance]), 'Table (2)'[Position] <= MAX('Table (2)'[Position]))

OutBlanace(RTotal) = CALCULATE(sum('Table (2)'[OutBalance]), 'Table (2)'[Position] <= MAX('Table (2)'[Position]))

RTotal_Difference = [InBlanace(RTotal)] - [OutBlanace(RTotal)]

Hope this helps.

[Anonymous]

Hi PBI Community!

Still need help with this. This is not resolved. 

Any help would be much obliged!

Mvh

[Anonymous]

Hi @Idrissshatila Thank you. I have tried but i think that i need som help with the syntax.

BR
/D

[Idrissshatila]

Hello,

This article will help you solve your problem.

https://www.daxpatterns.com/cumulative-total/

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin