Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Create a measure that is basically:

 

Measure = SUM([Sales])

Measures are context aware, meaning that if you display this measure in the context of "all" you will get the total of everyone but if you select a person from a slicer you would get just that one person. Note that you should be able to use the default "sum" aggregation and really not have to create the measure at all for something as simple of a calculation as this.

ewuchatka's avatar
ewuchatka
Helper II
9 years ago

Hi Greg_Deckler

 

Thank you

 

What about Running Totals?

 

Sorry, I might have not been clear, but I am looking into running totals, I thought Running Totals are the same as Cumulative, but I realise that Cumulative :)

 

So Period 1 will show Period 1 totals, Period 2 will show Period 1 plus Period 2, Period 3 will show Period 1+2+3.

 

Thanks

 

Ewa

  • CahabaData's avatar
    CahabaData
    Memorable Member
    9 years ago

    Some aspects of your post are unclear.  But for a running sum you will definitely need an Index column.  You add that via the Query Editor where there is an Add Column tab.

     

    There could be an overall running sum - or - a running sum by Period which would reset at the start of a new period.  But then you are asking for i.e. Period 3 to include Period 1 & 2 totals - so that isn't clear as to which you actually seek.

     

    Another approach is your Period in Visuals you can set them up to be a hierarchy and you might experiment with that without any custom DAX needed.