Forum Discussion

Resolver I

5 years ago

Solved

Summerize DistinctCount by date

how can i caclute the bookingdays sum of my distinct sprint_Days?? how can i take this Result: thanx for your Idee! Best Greetings

amitchandak
5 years ago
lboldrino , Try like

sumx(summarize(Table, Table[sprint_nr], Table[employee], "_1",DistinctCount(Table[String_day])),[_1])

Super User

5 years ago

lboldrino , Try like

sumx(summarize(Table, Table[sprint_nr], Table[employee], "_1",DistinctCount(Table[String_day])),[_1])