Forum Discussion

suraj-k-mishra's avatar
suraj-k-mishra
Regular Visitor
4 years ago
Solved

Dax expression for counting total time for Issue type

Hi Folks ,  I have a table in which I have  infomation about Sprint activity. I have column issue type , liked issueand total time for issue .  I want to calculate  total time for a issue and relate...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, suraj-k-mishra 

    Try formulas as below:

    Column = 
VAR _t =
    SUMMARIZE ( FILTER ( 'Table', [Key] = EARLIER ( 'Table'[Key] ) ), [linked key] )  
RETURN
    SUMX (
        FILTER ( 'Table', CONTAINSSTRING ( _t, [Key] ) ), 
        'Table'[spent time(in sec)]
    )     // For the current row key, filter all related keys in virtual table _t, and then add their values
    Total time = 'Table'[spent time(in sec)]+'Table'[Column]

    Best Regards,
    Community Support Team _ Eason

suraj-k-mishra's avatar
suraj-k-mishra
Regular Visitor
4 years ago

Thanks vahid for looking,
I think you didn't got my point-  I want to calculate total time for Key+total time for linked issue with that key . 

For exp - In screnshot , In key column DACSDEV-775 is having 5 linkked issues. I want to calculate sum of total time spent in DACSDEV 775+ time spent linked issue 
 let me know if  above explanation  you got it. 

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, suraj-k-mishra 

I did not see any relevant screenshots, can you upload (not paste) your photos again?

It would be great if you can share your sample file  (link of cloud storage) and expected result here.

 

Best Regards,
Community Support Team _ Eason

 

  • suraj-k-mishra's avatar
    suraj-k-mishra
    Regular Visitor
    4 years ago

     I want to calculate total time spent for a task +  include total time spent with  linked   task. 

     

     

    for exp task1 have two linked task - task 2 and task3 , so total time for task 1 is  3000+3890+3456.
    hope you got it , 

    thanks for looking

     

     

     

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      4 years ago

      Hi, suraj-k-mishra 

      Try formulas as below:

      Column = 
VAR _t =
    SUMMARIZE ( FILTER ( 'Table', [Key] = EARLIER ( 'Table'[Key] ) ), [linked key] )  
RETURN
    SUMX (
        FILTER ( 'Table', CONTAINSSTRING ( _t, [Key] ) ), 
        'Table'[spent time(in sec)]
    )     // For the current row key, filter all related keys in virtual table _t, and then add their values
      Total time = 'Table'[spent time(in sec)]+'Table'[Column]

      Best Regards,
      Community Support Team _ Eason