DistinctCount with condition, 2nd version!

[AnthonyXelya]

I also have a question with DistinctCount : I have a table with downtimes impacting several customers, I would like to have the sum of downtimes durations regardless of how many customers they impact :

For example : 

I would like to have 70 here : 10 + 15 + 45

and not 90 (the sum of every lines) or 18 (90/5).

How can I have that with a measure?

Thank you!

[amitchandak · Accepted solution]

@AnthonyXelya , Try measure in one of the two ways

sumx(summarize(Table, Table[downtimeID], Table[downtimeDuration]),[downtimeDuration])

or

sumx(summarize(Table, Table[downtimeID], "_1", max(Table[downtimeDuration])),[_1])

[jameszhang0805 · Accepted solution]

Is this OK?

or 

[amitchandak · Accepted solution]

@AnthonyXelya , Try measure in one of the two ways

sumx(summarize(Table, Table[downtimeID], Table[downtimeDuration]),[downtimeDuration])

or

sumx(summarize(Table, Table[downtimeID], "_1", max(Table[downtimeDuration])),[_1])