Cumlative sum with only distinct values

[Yazid]

Dear,

I have the following table: 

Where I'd like to create a column with the cumulative sum of the "YTD_Actuals_per_project" in fuction of distinct values for "Project_Act"

Hope I was clear enough.

Thnaks in advance for your support.

[rajendraongole1]

Hi @Yazid - We will use measure for Metrics, can you please try to create a new measure using below calculation

Cumulative YTD Actuals =
CALCULATE(
SUM('YourTableName'[YTD_Actuals_per_project]),
FILTER(
ALLSELECTED('YourTableName'),
'YourTableName'[Project_Act] <= MAX('YourTableName'[Project_Act])
)
)

you can create a measure that calculates the cumulative sum of YTD_Actuals_per_project based on distinct Project_Act values and drag and drop on report view and check the results. it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Yazid]

Dear,

Thanks for you reply ! However, it should be an increasing function like the green curve..

Should I try something else ?