Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculating time difference...

Hi guys,   I have a dataset with the history of changes to items. Some of those items have been 'tagged' as blocked on certain dates. Whilst I've managed to calculate the total time an item has sp...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi Anonymous ,

 

Create a measure as below:

Measure = SUMX(ALL('Table'),'Table'[Column 2])

And you will see:

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks - unfortunately that doesn't seem to work, and is summing for all the items in that table (there are multiple different work item ID's)...any ideas?

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Could you pls upload your .pbix file to onedrive business and share the link with us?Remember to remove the confidential information.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous ，

     

    If it's not convinient to provide your data,would you pls make a more detailed sample data for me to test?

     

    Or you may try use below measure :

    Measure=SUMX(ALLSELECTED('TABLE'[Client Azure DevOps]),'Table'[Column 2])

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!