How to make a total sum for measure values within a DAX formula

[Anonymous]

Dear All,

I have a simple table, which contains a measure showing the difference between prices of latest month and previous month (measure called 'Delta previous price'. See below simplified example: 

How can I make a total sum of the measure 'Delta previous price'? A simple SUM or SUMX does not work. 

Thanks for providing any suggestion.

[Thennarasu_R · Accepted solution]

Hi !
@Anonymous 
Use this Measure

Previous Month=CALCULATE(SUM(Finacial[Sales]),PREVIOUSMONTH('Date'[Date]))

Thanks,
Thennarasu

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

According to your description, you want to calculate the sum of a measure .

If this , you can refer to :

(1)This is my test data:

(2)We can just create a  measure like this:

Measure = SUMX( VALUES('Table'[Date]) ,[My Measure])

(3)Then we can meet your need:

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[aistraus]

This worked perfectly for me, thank you!

[Anonymous]

Perfect! This works!

[MahyarTF]

Hi,

If you are looking for have a correct sum of the difference value, try to create the calculated column instead of the measure. it will be calculate the correct sum :

See below image that I create the new column  :

Appreciate your Kudos and please mark it as a solution if it helps you.

[Anonymous]

Hi,

If you only want to display the total account in the table, you can activate the total option in the table format. If you are going to use this value in other calculations, you can create the Running total formula with "New quick measure".

I created a demo for you, hope it helps 🙂

[Thennarasu_R · Accepted solution]

Hi !
@Anonymous 
Use this Measure

Previous Month=CALCULATE(SUM(Finacial[Sales]),PREVIOUSMONTH('Date'[Date]))

Thanks,
Thennarasu

[Anonymous]

Thanks for your suggestion. How can I make this without the Date table? Looking for a solution of just make a sum on a measure.