Calculation groups for cumulative total DAX Pattern

[Anonymous]

I'm playing around with the very helpful cumulative total DAX pattern from @marcorusso and wondered whether it could be turned into a calculation group, providing a flexible way to report cumulative totals for multiple measures

I've tried (making a slight change to the published pattern) but I'm doing something wrong - whether because it's not possible or because I just can't figure it out, I don't know : )

Is this something anyone else can see a way to achieve?

In contrast, I've used a calculation group to create a Min, Max, Latest pattern for adding data labels to time series data so I'm hopeful it's possible - ends up like this:

[marcorusso · Accepted solution]

Perhaps you want to use:

VAR FirstVisibleDate =
    CALCULATE ( MIN ( _Dates[Date] ), ALLSELECTED ( _Dates ) )

 then you can get rid of the IF statement and add a condition Dates[Date] >= FirstVisibleDate in the CALCULATE function.

[Anonymous]

As aways, @marcorusso, you're an absolute legend

Thanks - seems to work perfectly!

I'm finding it helpful to use calculation groups in this way and I wondered if I'm doing something unreliable or niche, as I haven't seen other examples of people doing it

[parry2k]

@Anonymous it is not clear what your expectations are?

[Anonymous]

Hi @parry2k 

In my message I posted two pictures. In the first picture, I showed two columns. In the second column, I would like to return cumulative total. I would like to achieve this by having the measure in the "values" part of the visual and the calculation group in the "columns" part:

However, the calculation doesn't work because the values are clearly not a cumulative total of the first column. 

My goal / expectation is for the calculation group to return the cumulative total.

Does this make sense?