Count of absences per day

[syasmin25]

Hello,

Hope you all are doing well. I was working on something and am pretty new to DAX. I’m trying to the total count of people who are absent in a day. However the database tends to track absences by period. Thus, I can find a person having a few records within a day. I was wondering if there was any way I count do a count of each person using their unique ID just once. I have a sliver that has dates.

Any help will be appreciated. Thank you!

[Greg_Deckler]

Yes, you should be able to but will depend on your data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

You may find this useful: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

[syasmin25]

Hello, 

So I am providing a sample here. I am trying to count the number of students that are absent for more than 4 periods in a day. I will be having a slicer than can go back to a previous date to number of students that are absent for more than 4 periods to be counts within the range that a user might want to see it. Thus I suppose, just a distinct count of the "ID" won't do. Please help me out!

School_Name	Absent_Date	Name	Period	Student_ID
School_1	2/27/2020	John	3	258
School_2	2/28/2020	Harry	3	101
School_3	3/12/2020	Hermione	1	225
School_4	3/11/2020	Ginger	1	747
School_2	2/28/2020	Harry	4	101
School_2	2/28/2020	Harry	5	101
School_2	2/28/2020	Harry	6	101
School_2	2/28/2020	Harry	7	101
School_2	2/28/2020	Harry	8	101
School_3	2/25/2020	Hermione	2	225
School_3	2/25/2020	Hermione	3	225
School_3	2/25/2020	Hermione	4	225
School_3	3/12/2020	Hermione	3	225
School_3	3/12/2020	Hermione	4	225
School_3	3/12/2020	Hermione	5	225
School_3	3/12/2020	Hermione	6	225
School_3	3/12/2020	Hermione	7	225
School_4	3/11/2020	Ginger	2	747
School_4	3/11/2020	Ginger	3	747
School_4	3/11/2020	Ginger	4	747
School_4	3/11/2020	Ginger	5	747
School_4	3/12/2020	Ginger	1	747
School_4	3/12/2020	Ginger	2	747
School_4	3/12/2020	Ginger	3	747
School_4	3/12/2020	Ginger	4	747
School_1	1/31/2020	Jane	1	500
School_1	1/31/2020	Jane	2	500
School_1	1/31/2020	Jane	3	500
School_1	1/31/2020	Jane	4	500
School_2	3/13/2020	Ron	1	699
School_2	3/13/2020	Ron	2	699
School_2	3/13/2020	Ron	3	699
School_4	3/12/2020	Ginger	5	747
School_4	1/25/2020	Ginger	3	747
School_4	1/25/2020	Ginger	4	747
School_4	1/25/2020	Ginger	5	747
School_1	2/28/2020	John	1	258
School_1	3/10/2020	John	3	258
School_1	3/11/2020	John	3	258
School_1	3/13/2020	John	1	258
School_1	3/13/2020	John	2	258
School_1	3/13/2020	John	3	258
School_1	3/13/2020	John	4	258
School_1	3/13/2020	John	5	258

Sample raw shot of the visual is below (the number of students are from a different table that depicts the total number of students enrolled in the schools) 
** The real data is much much bigger.