Summerize DistinctCount by date

[lboldrino]

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 · Accepted solution]

@lboldrino , Try like

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

[amitchandak]

@lboldrino , In this case , this should work

DistinctCount(Table[String])

[lboldrino]

Ii need to sum Bookingdays pro sprints: