cumulative sum with one value

Hi Anonymous,

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