cumulative sum with one value

[ATTAR]

Hello all,

I am trying to make a cumulative sum with one value is that possible ?

Dataset : 

the idea is to have a linear curve like this : 
the first point will be 876 935, the second one 876 935*2, the third 876 935*3 etc. 

I tried this but not working : 

Thanks

[Anonymous]

Hi @ATTAR,

AFAIK, selectedvalue function does not suitable to handle aggregate row context. If you not setting 'alternate result', it will return blank when this function works with aggregate contents.

SELECTEDVALUE function - DAX | Microsoft Docs

For this scenario, I'd like to suggest you do some process to add variables with summarize function to manually group and calculate records with these categories at the detail level. Then you can invoke this measure with other formula calculations.

BTW, if this calculation includes multiple aggregations. You may need also to set multiple level aggregations in the formulas. (use summarize function calculates the first level, then use iterator function to summary previous results)
Regards,

Xiaoxin Sheng

[Greg_Deckler]

@ATTAR Try the Running Total quick measure built into Power BI Desktop. 

Sum of Column1 running total in Date = 
CALCULATE(
	SUM('Table7'[Column1]),
	FILTER(
		ALLSELECTED('Dates'[Date]),
		ISONORAFTER('Dates'[Date], MAX('Dates'[Date]), DESC)
	)
)

[ATTAR]

thank you for trying but it's not working. 

I got this result ( the orange line)

[VahidDM]

Hi @ATTAR 

Can you share a fomula you used to create this chart (how did you add Greg solution to your report)?

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[ATTAR]

Hello @VahidDM 
Yes sure ; 
I added EarnoutStart on purpose for business purposes.