Continuously adding value of result in graph.

[ConsatSudbury]

I have a table with bus stop activity for every stop on the route. (ex: 4 in and 2 out.) this would be an ONBOARD change of +2. 

I've managed to show a graph with the average change in th ONBOARD but I heed it to add from the previous.

So, with my selected route, the above shows first stop has an average boarding of 3.35 passengers. The second stop has an average boarding of 1.5 but I want the graph to show the average ONBOARD value of 4.75 (1st stop plus 2nd stop). The next stop has a value of -1.5 so the graph should show ONBOARD 3.25. What is th best way to make this happen?

[v-jingzhang · Accepted solution]

Hi @ConsatSudbury 

You can create the following measures in the report, then add the second measure to the column chart. 

Average of InOutChange = AVERAGE(Data[InOutChange])

Cumulative InOutChange = 
SUMX (
    FILTER (
        ALLSELECTED ( 'Data'[SequenceInJourney] ),
        'Data'[SequenceInJourney] <= MAX ( 'Data'[SequenceInJourney] )
    ),
    [Average of InOutChange]
)

Below is the result of above measures. I haved attached the sample pbix at bottom for your reference. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[ConsatSudbury]

Im my data, I have a column for IN, OUT, and another ( IN - OUT ) called InOutChange.

[amitchandak]

@ConsatSudbury , In case you need sum of Avg. Assume you have measure Avg

Sumx(Values(Table[Stop]), [Avg])

If You do not use measure , then use calculate example

Sumx(Values(Table[Stop]), calculate(Average(Table[Duration] )) )