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

Here key is an issue type

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi suraj-k-mishra 

 

if you want a measure, try this:

 

measure = calculate(SUM(sheet2[time spent]), ALLEXCEPT(sheet2,sheet2[Key]))


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

Appreciate your Kudos!!



  • 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