Forum Discussion

AnthonyXelya's avatar
AnthonyXelya
Helper II
5 years ago
Solved

DistinctCount with condition, 2nd version!

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's avatar
    amitchandak
    5 years ago

    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])

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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])