cumulative average with dax

[Anonymous]

here is the data

I want to get cal that is result of cumulative value divides the number of the rows calculated,

for example, when id is C, the cumulative value is 6 and number of row is 3( consider the filter and context) so the result is 2

do you have any ideas? Thank you.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could simply add an index column then use cumulative value divide the index column.

Or create a rank column based on cumulative value.

If there is a negative value, take the absolute value and then calculate the cumulative value.

Best Regards,

Jay