Forum Discussion

Barrie2020's avatar
Barrie2020
Frequent Visitor
6 years ago
Solved

HHMMSS Duration Total

I currently have a column titled PlayedTime which has seconds converted to show as HH:MM:SS - this appears to be ok   I have a quick measure titled TotalPlayedTime which uses this formula:  TotalPl...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Barrie2020 ,

     

    Try use SUMX() function instead SUM().

    https://docs.microsoft.com/en-us/dax/sumx-function-dax.

    sumx(table,[TotalPlayedTime])

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Barrie2020 ,

 

Can't see your sample data.

But you can check the following steps and see if the result achieve your expectation.

1# Refer to the below topic to convert your PlayedTime to hh:mm:ss.

https://community.powerbi.com/t5/Desktop/How-to-convert-seconds-to-hh-mm-ss/td-p/310219.

2# Use your formula above to create a measure.

3# convert the measure to hh:mm:ss format.

Result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

  • Barrie2020's avatar
    Barrie2020
    Frequent Visitor
    6 years ago

    Hello

     

    Apologies for the delay

     

    I have redone the formula following the steps in the above link as advised, i now have a Custom Column titled TIME which is a Data Type of TIME 

     

    TotalPlayedTime in the image below is a MEASURE based n this formula: 

     

    TotalPlayedTime = CALCULATE(SUM('1'[Time]))

     

    That gives me the result below

     

    I have tried to create a duration measure based on this which does not work 

     

    Duration = MAX( '1'[TotalPlayedTime] ) - MIN( '1'[TotalPlayedTime] )
     
    I Cannot use a Calculate Sum formula as TotalPlayedTime is a measure and not a column
     
    Any help for the overall total would be welcome

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Barrie2020 ,

       

      Try use SUMX() function instead SUM().

      https://docs.microsoft.com/en-us/dax/sumx-function-dax.

      sumx(table,[TotalPlayedTime])

       

      Best Regards,

      Jay

      Community Support Team _ Jay Wang

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