Summarize and group by (??)

Hi r9nv9 ,

Here a way on how to achieve the desired result by creating a new table:

Table_New = 
SUMMARIZE (
    'Table',
    'Table'[ID],
    "Time to launch app", DATEDIFF ( CALCULATE ( SELECTEDVALUE ( 'Table'[DateTime] ), 'Table'[Activity] = "Login" ), CALCULATE ( SELECTEDVALUE ( 'Table'[DateTime] ), 'Table'[Activity] = "LaunchApp" ), MINUTE ),
   "Time to start work", DATEDIFF ( CALCULATE ( SELECTEDVALUE ( 'Table'[DateTime] ), 'Table'[Activity] = "Login" ), CALCULATE ( SELECTEDVALUE ( 'Table'[DateTime] ), 'Table'[Activity] = "StartWork" ), MINUTE )
)

I am not sure though, if that is what you are looking for. You might be more interested in two separate measures. Here an example:

Measure_time_to_launch_app = 
DATEDIFF ( 
    CALCULATE ( 
        SELECTEDVALUE ( 'Table'[DateTime] ), 
        'Table'[Activity] = "Login" 
    ), 
    CALCULATE ( 
        SELECTEDVALUE ( 'Table'[DateTime] ), 
        'Table'[Activity] = "LaunchApp" 
    ), 
    MINUTE 
)

Measure_time_to_start_work = 
DATEDIFF ( 
    CALCULATE ( 
        SELECTEDVALUE ( 'Table'[DateTime] ), 
        'Table'[Activity] = "Login" 
    ), 
    CALCULATE ( 
        SELECTEDVALUE ( 'Table'[DateTime] ), 
        'Table'[Activity] = "StartWork" 
    ), 
    MINUTE 
)

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/