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,

Based on my test, you could refer to below steps:

Unpivot your Creation and Closure column in query editor:

Result:

Apply it and create below measures:

Measure = CALCULATE(COUNT(Table1[Value]))
Measure running total in value = 
SUMX(FILTER(ALLSELECTED(Table1[Value]),'Table1'[Value]<=MAX('Table1'[Value])),[Measure])

Result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He