Forum Discussion

JorgeGuajardoH's avatar
JorgeGuajardoH
New Member
4 years ago
Solved

Cumulative Sum Measure Not Working Properly

Hello,   I'm fairly new using power BI, and I need to create a table with a cumulative sum of cases left open for each day/week/month/year   I created masures from my table to substract created  ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    This is caused by current row content. A month corresponds to multiple dates, which is the cause of the issue.

    Try to create a year month column as a condition to create a measure.

    Measure = CALCULATE(SUM('Table'[Backlog]),FILTER(ALLSELECTED('Table'),'Table'[sort_month]<=MAX('Table'[sort_month])))

     

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

This is caused by current row content. A month corresponds to multiple dates, which is the cause of the issue.

Try to create a year month column as a condition to create a measure.

Measure = CALCULATE(SUM('Table'[Backlog]),FILTER(ALLSELECTED('Table'),'Table'[sort_month]<=MAX('Table'[sort_month])))