Count is not matching

[Anonymous]

Hello great people. I am stuck up here. Appreciate your help to figure out the exact count.

ID	Overall Status	Progress Status (If In-Progress)	Risk Rating	Client Legal Name	Scheduled Completion Date (calc)	Actual Complete Date
5	Removed		Medium	A	5/27/2022
6	Completed		Medium	B	7/8/2021	12/19/2021
7	In-Progress		High	C	9/2/2021	10/20/2021
8	Completed		High	D	8/26/2021	10/20/2021
9			High	E	7/21/2021	11/25/2021
10	In-Progress		High	F	4/18/2022
11	In-Progress		High	G	10/21/2021
12	Completed		High	H	4/19/2022	3/24/2022
13	Completed		High	I	6/22/2022	3/24/2022
14	In-Progress		High	J	6/27/2022

Measure Count = Overall Status="Completed"||Overall Status="In-Progress"||Overall Status=Blank() AND Scheduled Completion Date (calc)= <Today() AND Actual Complete Date = BLANKS() The result I am expecting is 2. I am not getting that. Anyone could help me to create the formula.

Appreciate your help. 

[mohammedadnant · Accepted solution]

Hi @Anonymous 

Pls try this, 'Table' is the table name

Measure Count = 

CALCULATE( COUNT('Table'[ID]), 
'Table'[Overall Status] in {"Completed", "In-Progress"} || 'Table'[Overall Status]= Blank(), 
'Table'[Scheduled Completion Date (calc)]<=Today() ,'Table'[Actual Complete Date] = BLANK()
)