cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Sum of Cumulative

Hi! The requirement is to get the total number of accounts as of the month. So what I did is I created a measure that gets the cumulative value. However, looking at the sum, it didn't add up all the values. Anyone can help me on this please?

4 REPLIES 4
Community Support Team

## Re: Sum of Cumulative

Hi @ogureisuo ,

Based on my test, you could use SUMX function to solve your problem:

[Measure] is your running total measure

Create below measure:

`Measure 2 = SUMX('Table1',[Measure])`

Result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: Sum of Cumulative

Can you share the dax of your measures?

Thanks

Regular Visitor

## Re: Sum of Cumulative

Hello,

I tried the measure but it didnt work.

Here's my measure:

Accounts =
CALCULATE(COUNT(Account[accountid]), Account[statecode] = 0, USERELATIONSHIP(Account[createdon], 'Date dimension'[Date]),
FILTER (
ALL ( 'Date dimension'[Date] ),
'Date dimension'[Date] <= MAX ( 'Date dimension'[Date] )
)
)
Community Support Team

## Re: Sum of Cumulative

Hi @ogureisuo ,

You could try to with HASONEVALUE function or ISFILTERED function to calculated your data, below links that may have the same problem with you:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

https://community.powerbi.com/t5/Desktop/Measure-Total-not-correct/td-p/495362

If it still could not help you, I suggest you offer your pbix file that I could test for you.

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.