Best way to Sum, not count or first/last duration of each queue time in a PowerBI Matrix Visual?

[dubya]

Hello, 

I am attempting to replace Cells B2 and B6 with the sum of the below durations, the Matrix seems to give Count or First/Last options. 

 

Thank you!

[audreygerred]

Hello! First, change your column to Time. This is the key to being able to create a measure to sum them. Once you change your column to Time type you can create a measure of Total Time = SUM('YourTable'[Time])

[dubya]

Thank you for your response, I should have added the duration column is a text type as I am using a formula to derive that time value from a decimal. 

Are you able to assist further? 

[audreygerred]

Hi, yes, you need to change the field to Time type. With text you can only do first, last, count...

In the data pane, go to your Time field and click on it... then go to the Column Tools ribbon at the top and change Text to Time in Data type.

[v-denglli-msft · Accepted solution]

 Hi @dubya ,

You can create a measure to sum the duration of each queue.

Below is the data table.

The measure is as follows.

First Duration = SUM('Table'[Time])

 
The final result is as follows, hopefully it will fulfill your needs.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

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

[dubya]

Thank you for your response, I should have added the duration column is a text type as I am using a formula to derive that time value from a decimal. 

Are you able to assist further? 

[v-denglli-msft]

Hi @dubya ,

May I ask if you have gotten this issue resolved?

 If it is solved, please mark the helpful reply or share your solution and accept it as solution.

If not resolved, please provide sample data. We can better understand the problem and help you. 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Dengliang Li

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

[MattAllington]

What is the data format of the column?  Sounds like it is text. Change it to time

[dubya]

Thank you for your response, I should have added the duration column is a text type as I am using a formula to derive that time value from a decimal. 

Are you able to assist further?