Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cumulative Totals using measure

  I have the following simple matrix.                     I need to be able to cumulativly add up the mins value for that dayno. and the previous cumulative value. So in this exampl...
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    In your table, the Desired column has some error from row DayNo 0 to 4, it should be 7688 1424 1119 920 790 692.

     

    In my test, create a Measure as [Mins] in your original dataset, then calculate based on the [Mins] measure

    Measure 2 = SUMX(FILTER(ALL(Sheet1),[DayNo]>=MAX([DayNo])+1),[Measure])

Measure 3 = [Measure]+[Measure 2]

     

     

    Best Reagrds

    Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This doesnt appear to be working when using a measure:

 

 

 

 

As you can see; 6264 + 1162 does not equal 8540, 

                         305 + 901 does not equal 1162, 

                         etc.

 

However trying this on my example workbook where values are column stored, this does work. Any ideas why the measure is throwing it off?

 

The calc I used is:

RepeatMinsSaved(Cummulative) = CALCULATE([Repeat Mins Saved],FILTER(ALL('Table'),MAX('Table'[DayNo]) <= 'Table'[DayNo]))

 

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous

In your table, the Desired column has some error from row DayNo 0 to 4, it should be 7688 1424 1119 920 790 692.

 

In my test, create a Measure as [Mins] in your original dataset, then calculate based on the [Mins] measure

Measure 2 = SUMX(FILTER(ALL(Sheet1),[DayNo]>=MAX([DayNo])+1),[Measure])

Measure 3 = [Measure]+[Measure 2]

 

 

Best Reagrds

Maggie