Filtered Quick Measure is showing a different value than when I manually filter the column

[Anonymous]

Hello Power BI community,

I'm not too familiar with DAX code and creating measures, so I used the Power BI quick measure option to create a count and filter one of my columns. It was very easy to make and it developed a measure with this code:

Quick Measure = 
CALCULATE(
	COUNTA('Open_Assignments'[Open_Summary]),
	'Open_Assignments'[Open_Summary] IN {
		"Ad hoc",
		"Consultation",
		"Data Management",
		"Data Sharing Agreement",
		"Flag",
		"Map/Global Information System",
		"Program Evaluation",
		"Research",
		"Survey",
		"Workgroup"
	}
)

 However, when I manually filtered the column to double-check the quick measure's result, I found that the measure didn't align:

Does the syntax of the measure look off?

I appreciate your help.

[Anonymous · Accepted solution]

I ended up using a different filtering syntax that worked:

FilteredRequests = 
COUNTROWS(
    FILTER(
        'Open_Assignments',
        'Open_Assignments'[Request_Type] <> "Report"
    )
)