Forum Discussion

BartVanH's avatar
BartVanH
Frequent Visitor
7 years ago
Solved

Running total for 'row count'

Hi,   I'm looking for a variant of the often mentioned running total calculation. My data does not contain the numbers to add up in the running total, like most Sales data examples around. My dat...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi BartVanH, 

    You could refer to modifying your formula as below:

    Measure running total in value = 
SUMX(FILTER(ALLEXCEPT(Table1,Table1[Attribute],Table1[Legend],Table1[Nr]),'Table1'[Value]<=MAX('Table1'[Value])),[Measure])

    Result:

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi BartVanH, 

You could refer to modifying your formula as below:

Measure running total in value = 
SUMX(FILTER(ALLEXCEPT(Table1,Table1[Attribute],Table1[Legend],Table1[Nr]),'Table1'[Value]<=MAX('Table1'[Value])),[Measure])

Result:

Regards,

Daniel He

BartVanH's avatar
BartVanH
Frequent Visitor
7 years ago

Beautiful, thanks!