Forum Discussion

pgiorgi1's avatar
pgiorgi1
Frequent Visitor
4 years ago

Cannot get Dax to average.

Ok I am stumped on this one, I have an excel spreadsheet that includes these columns 

 

AssetUUIDtimeHappenedUTCTitle
1258006/01/2021 3:14:14PMSOS
1258006/01/2021 3:15:14PMEmergency
1258006/01/2021 3:15:45PMSOS Cancel
158008/01/2021 2:25:30AMLOGIN
1255807/01/2021 4:20:15AMSOS
1255807/01/2021 4:35:15AMSOS Cancel

 

The Goal is to look at the average time to cancel so I build a calculated column to calculate the date difference between 'SOS' and 'SOS Cancel' that looks like this 

 

Open to close = VAR SOSEmergency = CALCULATE(MAX('User Data'[timeHappenedUTC]),FILTER('User Data',[title] = "SOS"))
VAR Cancel = CALCULATE(MAX('User Data'[timeHappenedUTC]),FILTER('User Data',[title] = "SOS Cancel"))
RETURN DATEDIFF(SOSEmergency,Cancel,MINUTE

 

 

 I've been able to validate the times are accurage I have these times appearing between 1 and 57 minutes so that works. 

 

I am having a huge issue trying to get an average time from open to close: anything I do with averages show up as the highest time closed of 57 minutes, no matter what I do I seem to be missing the average.  any ideas?

average of a measure
DATEDIFF

1 Reply

  • m3tr01d's avatar
    m3tr01d
    Continued Contributor
    4 years ago

    pgiorgi1 Can you show us what measure did you try to get the Average?
    Maybe a picture of a table and the result you currently have?

    Since you already have a calculated column that seems to work, you could also try this :

    AVERAGEX(
	VALUES( Table[AssetUUID] ),
	Table[YourCalculatedColumn]
)