Create a cumulative column that varies each time you filter a variable

[CarlosOlmos29]

Hello power bi community. I would like to create a column where values are accumulated, and this accumulated change when filtering by a variable. 

In the attached image, the column ACUM OIL REAL is a dax measurement, I would like to create it as a column and have it change when I filter the variable WELLBORE. In the images you can see that when I select AKA04i in the WELLBORE column the accumulated is different than when I select AKA30i.

I would like to create that as a column because I want to use in another calculate in another column and as a measure it doesn't allow me to add it in the visual.

Thank you very much in advance for your help. I hope I have made myself clear.

[amitchandak]

@CarlosOlmos29 , The running total or cumulative seems fine to me as measure

If you need a column, that will not dynamic and will not respond to filters

A new column 

Sumx(filter(Table, [Wellbore] = earlier([Wellbore]) &&  [Volume_date] <= earlier( [Volume_date]) ), [Oil Real BLS])

Power BI DAX- Earlier, I should have known Earlier: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

for measure

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f