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
    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. 

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity 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