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

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