calculating a total of multiple rows in the same table

[nick9one1]

I'm building a report that displays some basic stats from Microsoft teams presentations. 

Sample of the table below filtered to a single user. 

I have added some calculated columns to clean up the data. 

Time on call - difference in minutes between the Joined and left actions of the same session ID. 

Valid - if a user joins before or after the call has started or ended. 

What I now need to do is create a 'total' for each user for each call. 

e.g. some users might disconnect from a call, then reconnect so they have two sessions of 30 minutes. Where this has happened I need to add those values together. 

I'm not sure of the best way to achieve this, either summary table, or measure. Or another way? 

My final report will look like this

[nick9one1 · Accepted solution]

I figured it out. Quite simple in the end, just needed a summary table. 

Summary = SUMMARIZE(cr20b_vccalldata,cr20b_vccalldata[FullName],cr20b_vccalldata[Call Title], "Total Time on call",SUM(cr20b_vccalldata[Time on Call]))

[nick9one1]

00736070-e04f-4134-a4c9-1b5b2c656712

USER 1

USER1@TEST.COM

09/03/2023 15:03:55

Left

Attendee

March 2023

09/03/2023

3

March

False

20/03/2023

00736070-e04f-4134-a4c9-1b5b2c656712

USER 1

USER1@TEST.COM

09/03/2023 15:03:07

Joined

Attendee

March 2023

0

09/03/2023

3

March

False

20/03/2023

0

375c96b7-14ef-425b-a7be-f871f9907b5b

USER 1

USER1@TEST.COM

17/04/2023 10:59:07

Left

Attendee

April 2023

17/04/2023

4

April

True

17/04/2023

375c96b7-14ef-425b-a7be-f871f9907b5b

USER 1

USER1@TEST.COM

17/04/2023 10:41:54

Joined

Attendee

April 2023

18

17/04/2023

4

April

True

17/04/2023

18

3b0d53f9-0855-444c-b86e-6e8c990c3bf3

USER 1

USER1@TEST.COM

17/07/2023 10:00:12

Left

Attendee

July 2023

17/07/2023

7

July

True

17/07/2023

3b0d53f9-0855-444c-b86e-6e8c990c3bf3

USER 1

USER1@TEST.COM

17/07/2023 09:59:14

Joined

Attendee

July 2023

1

17/07/2023

7

July

True

17/07/2023

1

6b073673-fb52-48df-8152-f5e3b6ae93dd

USER 1

USER1@TEST.COM

17/07/2023 10:00:17

Joined

Attendee

July 2023

53

17/07/2023

7

July

True

17/07/2023

53

6b073673-fb52-48df-8152-f5e3b6ae93dd

USER 1

USER1@TEST.COM

17/07/2023 10:53:37

Left

Attendee

July 2023

17/07/2023

7

July

True

17/07/2023

8327f761-0da3-4455-a110-6d23d2e68f7d

USER 1

USER1@TEST.COM

20/03/2023 15:05:44

Joined

Attendee

March 2023

4

20/03/2023

3

March

True

20/03/2023

4

8327f761-0da3-4455-a110-6d23d2e68f7d

USER 1

USER1@TEST.COM

20/03/2023 15:09:59

Left

Attendee

March 2023

20/03/2023

3

March

True

20/03/2023

99d905a7-ac97-40e8-9f01-9f2d2cd89912

USER 1

USER1@TEST.COM

20/03/2023 15:10:11

Joined

Attendee

March 2023

52

20/03/2023

3

March

True

20/03/2023

52

99d905a7-ac97-40e8-9f01-9f2d2cd89912

USER 1

USER1@TEST.COM

20/03/2023 16:02:05

Left

Attendee

March 2023

20/03/2023

3

March

True

20/03/2023

cee5ad75-5c58-462a-8ecb-2cf0bb3de3dc

USER 1

USER1@TEST.COM

12/06/2023 10:02:24

Joined

Attendee

June 2023

55

12/06/2023

6

June

True

12/06/2023

55

cee5ad75-5c58-462a-8ecb-2cf0bb3de3dc

USER 1

USER1@TEST.COM

12/06/2023 10:57:11

Left

Attendee

June 2023

12/06/2023

6

June

True

12/06/2023

[foodd]

Thank you for replying with sample data as text.  Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied and suggest an answer customized to your situation.

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.