Calculate/SumAll Duration in specific intervals

[BlastS]

I have been working with a litle of dax function but still i am strunglig to get this exact thing which is:

I have as columns:

Index	TIME	ColumnF	Duration	ColumnX
1	30/07/2012 00:01:10
2	30/07/2012 00:01:20	0	10	0
3	30/07/2012 00:01:30	0	10	0
4	30/07/2012 00:01:40	0	10	0.2
5	30/07/2012 00:01:50	0	10	0.2
6	30/07/2012 00:02:00	0	10	0.2
7	30/08/2012 00:02:10	1	10	0
8	30/07/2012 00:02:20	0	10	0
9	30/07/2012 00:02:30	0	10	0.2
10	30/07/2012 00:02:40	0	10	0.2
11	30/07/2012 00:02:50	1	10	0
12	30/07/2012 00:03:00	0	10	0

The Output Should be = 50 (30 + 20)   in format like dd:HH:mm:SS ( 00 00:50:00)

What i want to do is to sum all the time duration when columnX is 0.2 (how can i sum each individually ) ?

How can i achieve this on powerbi ? 

[Anonymous · Accepted solution]

See if this helps:

Measure = 
CALCULATE(
    SUM(Table1[Duration]),
    Table1[ColumnX]=.20
)

[BlastS]

Hi, @Anonymous

That helps a litle but its not that i am exactly looking for. After that how you would convert to datetime?

[Anonymous]

Sorry, dont follow.  Could you possibly put what your expected output would be?

[BlastS]

HI, @Anonymous

Like each 10 of duration its 10 min so the output after sum all should be like 0 00:50:00 (means 0 days 0 hours 50 min 0 sec)

[v-yulgu-msft]

Hi @BlastS,

Here is a blog for your reference, please refer to it to convert minutes to duration.

Aggregating Duration/Time

Best regards,

Yuliana Gu