Performing a COUNT function that is based on dates

[water-guy-5]

I have a set of data that updates when a lab sample is taken for a certain facility. The requirement is that a sample needs to be taken by the 15th of each month, however each day day that a sample is not taken it records as "Not Checked". Facility A might look like this

7/1 "Not Checked"
7/2 "Not Checked"
7/3 "Not Checked"
7/4 "Not Checked"
7/5 "Not Checked"
7/6 "Not Checked"

7/7 "Not Checked"

7/8 "Not Checked"
7/9 "Not Checked"

7/10 "Not Checked"

7/11 "Sample Taken"

7/12 "Not Checked"

7/13 "Not Checked"

7/14 "Not Checked"

7/15 "Not Checked"

This satisfies the criteria, and I would like to count it as successful. 

So, in short, I need a measure that checks for "Sample Taken" in the first 15 days of a month (I will have the filter on "this calender month" so no need to worry about each month).

[Tahreem24 · Accepted solution]

@water-guy-5 ,
Try this measure:

Count = CALCULATE(COUNT(Tbl1[Status]),Tbl1[Status]="Sample Taken", DAY(Tbl1[Date])<=15)

[v-luwang-msft · Accepted solution]

Hi @water-guy-5 ，

Try the below measure:

count = CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Status]="Sample Taken"))

base data:

Visual：

when date choose 7/1 to 7/5:

when date choose 7/1 to 7/9:

Wish it is helpful for you!

Best Regards

Lucien

[Tahreem24 · Accepted solution]

@water-guy-5 ,
Try this measure:

Count = CALCULATE(COUNT(Tbl1[Status]),Tbl1[Status]="Sample Taken", DAY(Tbl1[Date])<=15)