Forum Discussion

Yazid's avatar
Yazid
Icon for Helper I rankHelper I
2 years ago

Cumlative sum with only distinct values

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 ...
Need Help
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

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's avatar
    Yazid
    Icon for Helper I rankHelper I
    2 years ago

    Dear,

     

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

    Should I try something else ?