Power BI doesn't take column value

[Syndicate_Admin]

Hi, maybe this is a basic question.

I have these three columns,

The first "Activation" is the original field without any summary

The second "Activation sum" is the "Activation" field with the sum summary

The third "Cumulative Activation Total" is a measure.

When I try to do some operation either comparison or some arithmetic, "Activation Sum" and "Cumulative Activation Total" do not reflect the displayed value, they take the value as if it were the "Activation" field and I need to take the value shown

[amitchandak]

@Syndicate_Admin ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Usually Cumulative is

example

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

[Syndicate_Admin]

Hello

Thanks for your answer, I am uploading in the following link a PBIX with test data (I couldn't upload it in response)

https://1drv.ms/u/s!Aj5NEb4bwbbHn6ZLBdSyjH0JAfZlBg?e=MwXWVg

The value I need to take is "Activation Sum" to be able to do a search in another table as I try in the "interval" column, I hope I am implying.