Need help with Dax

[Reshma_Doshi]

I have data as shown in the Image - which time spent in seconds on an App on various days. 

All columns are defined below. 

Col F is derived using Col B and Col E is derived using Col C. Values are repeated on each row in my dataset as data pertains to one user per day. 

I need to create a measure using dax where I can display "Sum of total time spent on this app per user" in minutes.   

Which is 234.25 seconds (6.17 +33.75+194.33 from Col G) / 3 users (Based on Unique count in Col A) / 60 (To convert into minutes).  

Looking forward to guidance. 

[Reshma_Doshi]

This helped! Thanks a ton. 

[Anonymous · Accepted solution]

Hi @Reshma_Doshi 

You can create a measure as follows

Measure = var a=SUMMARIZE(ALLSELECTED('Table'),[User id],[Month],[Distinct Date Count],[Sum of Duration in Secs],"Divide",DIVIDE([Sum of Duration in Secs],[Distinct Date Count])/CALCULATE(DISTINCTCOUNT('Table'[User id]),ALLSELECTED('Table')))
return SUMX(FILTER(a,[User id] in VALUES('Table'[User id])&&[Month] in VALUES('Table'[Month])),[Divide])/60

Output

Best Regards!

Yolo Zhu

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