How to average only one value for each SessionID?

[Anonymous]

Hi everyone, 

I have this problem with my table, I would like to only have one value for each Session ID, yet I am using this time stamp for calculations, so it takes average for all the value in the table, although they are the same ones: 

Is there any way how to filter one number per one Session? 

The value I need in total is (5341+177/2)= 2759 what is the Average per Session ID, any ideas? 

Please note: there are more values with 177 with different Session ID, so we can't just use unique values

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

averageX(values(Table[SessionID]), calculate(Max(Table[Sec Pageviews])))

[Anonymous]

yet again you saved my day, thanks @amitchandak!