Trying to calculate sum on a metric (DateDiff)

[DicksonJeff]

I have a metric calculating the difference between the first and last date in a series of date changes. 

Days Close Date Delta = DATEDIFF([First Close Date],[Last Close Date],DAY)

First Close Date is the min of TableName.CloseDate likewise the last close date is the max tablename.closedate table and field. 

My objective is to next create another metric that totals all of the differences that are found. Below is a table showing records and the date difference (delta) if there is one. Currently my formula to total the differences comes to 5 which is the count. I would like to see a total of 572 as an example. The logic seems simple but not being able to use a metric in a sum function is throwing me a wrench. 

Thanks in advance

[AlexisOlson · Accepted solution]

You can use a SUMX like this:

DeltaTotal =
SUMX ( VALUES ( TableName[Column] ), [Days Close Date Delta] )

Where [Column] is whatever column is the lowest level of granularity in your visual.

[AlexisOlson · Accepted solution]

You can use a SUMX like this:

DeltaTotal =
SUMX ( VALUES ( TableName[Column] ), [Days Close Date Delta] )

Where [Column] is whatever column is the lowest level of granularity in your visual.

[DicksonJeff · Accepted solution]

Thank you! i had been trying something similar but basing it off of the date field and not the id field. that fixed my issue!