Forum Discussion
Running total for 'row count'
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 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
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!