cancel
Showing results for
Did you mean:
New Member

## CUMULATIVE FOR EMAIL

Here is my Data

 Email Date Count Dan at abc.xyz 7/1/2020 18 Roxy at abc.xyz 7/1/2020 20 Sam at abc.xyz 7/1/2020 22 Dan at abc.xyz 8/1/2020 30 Roxy at abc.xyz 8/1/2020 40 Sam at abc.xyz 8/1/2020 50

I am trying to calculate this in POWERBI

 dan 48 48 roxy 60 108 sam 72 180

I am able to get the counts to work easily by calculation for cumulative is not working

Calculate(sum([count]), filter(all(table),table[email]<=max(table[email])))

1 ACCEPTED SOLUTION
Community Support

Hi @MEGHAMONTY ,

``````cumulative count =
CALCULATE (
SUM ( 'Table'[Count] ),
FILTER ( ALL ( 'Table' ), 'Table'[Email] <= MAX ( 'Table'[Email] ) )
)
``````

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

Hi @MEGHAMONTY ,

``````cumulative count =
CALCULATE (
SUM ( 'Table'[Count] ),
FILTER ( ALL ( 'Table' ), 'Table'[Email] <= MAX ( 'Table'[Email] ) )
)
``````

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Resident Rockstar

``````_sumCount:= SUMX('Table 1','Table 1'[Count])

_cumulativeTotal:=
VAR _1 = MAX('Table 1'[Date])
VAR _2 = CALCULATE([_sumCount],ALL('Table 1'[Date]),'Table 1'[Date]<=_1)
RETURN _2``````

New Animated Dashboard: Sales Calendar

Resident Rockstar

@MEGHAMONTYdid you try the above ?

New Animated Dashboard: Sales Calendar

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.