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 was clear enough.

 

Thnaks in advance for your support.

Need Help

2 Replies

  • 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 ?