How do you get the number of days of the week that a child is present?

[JoseHop]

 Hi, 

I have a tabel with child_id and a lot of dates that the child is present. I would like to know how many kids are 1, 2, 3, 4, or 5 days per week present? 

Tabel:

KIND_ID	DATE
241777	1-8-2022
241777	2-8-2022
241777	8-8-2022
241777	9-8-2022
241777	15-8-2022
241777	16-8-2022
241777	22-8-2022
241777	23-8-2022
241777	29-8-2022
241777	30-8-2022
241777	5-9-2022
241777	6-9-2022
241777	12-9-2022
241777	13-9-2022
241777	19-9-2022
241777	20-9-2022
241777	26-9-2022
241777	27-9-2022
241777	3-10-2022
241777	4-10-2022
241777	10-10-2022
241777	11-10-2022
241777	17-10-2022
241777	18-10-2022
241777	24-10-2022
241777	25-10-2022
241777	31-10-2022
241777	1-11-2022
241777	7-11-2022
241777	14-11-2022
241777	15-11-2022
241777	21-11-2022
241777	22-11-2022
241777	28-11-2022
241777	29-11-2022
241777	5-12-2022
241777	6-12-2022
241777	12-12-2022
241777	13-12-2022
241777	19-12-2022
241777	20-12-2022
235927	1-8-2022
235927	2-8-2022
235927	3-8-2022
235927	4-8-2022
235927	5-8-2022
235927	8-8-2022
235927	9-8-2022
235927	10-8-2022
235927	11-8-2022
235927	12-8-2022
235927	15-8-2022
235927	16-8-2022
235927	17-8-2022
235927	18-8-2022
235927	19-8-2022
235927	22-8-2022
235927	23-8-2022
235927	24-8-2022
235927	25-8-2022
235927	26-8-2022
235927	29-8-2022
235927	30-8-2022
235927	31-8-2022
234936	1-8-2022
234936	8-8-2022
234936	15-8-2022
234936	22-8-2022
234936	29-8-2022
234936	5-9-2022
234936	12-9-2022
234936	19-9-2022
234936	26-9-2022
234936	3-10-2022
234936	10-10-2022
234936	17-10-2022
234936	24-10-2022
234936	31-10-2022
234936	7-11-2022
234936	14-11-2022
234936	21-11-2022
234936	28-11-2022
234936	5-12-2022
234936	12-12-2022
234936	19-12-2022

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[JoseHop]

Thnx you, this really helps. 
What I'm exactly looking for is: in week 42 there is
2% 1 day present,
80% is 2 days present,
16% is 3 days present, 

1% is 4 days present,
1% is 5 days present.
Could you help me with that?

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[JoseHop]

Thank you some much. This really worked.

[Ashish_Mathur]

You are welcome.

[JoseHop]

@Greg_Deckler thnx for your reply. I did add WEEKNUM and WEEKDAY column. The SUMMERIZE is not going well. Can you write it out for me?

[Greg_Deckler]

@JoseHop Maybe something like this:

Measure 5 days = 
  VAR __Table = SUMMARIZE('Table',[KIND_ID],[WeekNum],"__Count",COUNTROWS(DISTINCT('Table'[Weekday)))
RETURN
  COUNTROWS(FILTER(__Table,[__Count]=5))

[Greg_Deckler]

@JoseHop Add a WEEKNUM column and a WEEKDAY column. Then you can SUMMARIZE by child and weeknum with a distinct count of weekdays.