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 related  linked issue for a issue. 
Any  lead would be appriciated.

 

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

6 Replies

    • VahidDM's avatar
      VahidDM
      Icon for Super User rankSuper 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.