Forum Discussion
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...
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
Hi v-danhe-msft,
Thanks a lot!
The calculation seems to work perfectly!
Here it is in a line graph:
However, when I select the Date Hierarchy in the field well:
It all reverts back to the individual values once I start drilling down...
I have a feeling I know why it's doing that, but is there any way around?
The first version is not my favorite, it's not the most aesthetic way to display the data.
But if there is no way around, I'll use that.
Thanks again!
Bart
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
Beautiful, thanks!