topic Re: CUMULATIVE TOTAL in DAX Commands and Tips

CUMULATIVE TOTAL

NessFlood — Wed, 04 Dec 2024 20:58:28 GMT

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

sevenhills — Wed, 04 Dec 2024 22:19:01 GMT

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!

NessFlood — Thu, 05 Dec 2024 02:05:41 GMT

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 — Thu, 05 Dec 2024 07:33:44 GMT

Please see below solution. hope this solves your ask

FreemanZ — Thu, 05 Dec 2024 22:34:33 GMT

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

cumulative total =

CALCULATE(

SUM(data[vehicles actual]),

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

)