How to average only one value for each SessionID?

Question

Hi everyone,&nbsp;&nbsp;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:&nbsp;&nbsp;Is there any way how to filter one number per one Session?&nbsp;&nbsp;The value I need in total is (5341+177/2)=&nbsp;2759 what is the Average per Session ID, any ideas?&nbsp;&nbsp;Please note: there are more values with 177 with different Session ID, so we can't just use unique values

amitchandak · Accepted Answer

Anonymous , Try a measure like 
averageX(values(Table[SessionID]), calculate(Max(Table[Sec Pageviews])))

Forum Discussion

How to average only one value for each SessionID?

2 Replies

Related content

Values not averaging correctly based on date

Average and Moving Average

Average value based on multiply samples per second, Average by minute

Weekly Average

Accumulated average