CUMULATIVE TOTAL

[NessFlood]

Hi there

I am after a cumulative total for Vehicle Actuals to include in a double axis visual.

I want the visual blue line axis to show 28 not two lots of 14

your help would be greatly appreciated 🙂

cheers

Vanessa

[FreemanZ]

hi @NessFlood ,

try to plot the visual with region column and a measure like:

cumulative total =

CALCULATE(

    SUM(data[vehicles actual]),

    data[region]<=MAX(data[region])

)

[NessFlood]

The measure works but it's not cumulative 😄

As more vehicle installations are completed across the regions, I need the blue line to increase - thank you 😀

[Rupak_bi]

Hi @NessFlood ,

Please see below solution. hope this solves your ask

[sevenhills]

Are you looking for a fixed line of 28? 

Count of Table Name total for Year = 
CALCULATE(
	Sum('Table1'[VEHICLES ACTUAL]),
	ALL('Table1')
)

Replace ALL with ALLSELECTED if you want to calculate with filters.

Use this measure for your line!