Report level filter by count of values

[Anonymous]

Is it possible to reference a report level filter in a DAX query?
I have a Date table and am trying to count the number of incidents that were closed on a specific day (easy enough)... however for my report I only want to reflect the number of incidents closed for a particular customer on each day.  I also only want to set my report critera in one place (ideally a report level filter) and don't wish to hard code the value into the DAX.

I've tried using SELECTEDVALUE on the field that's being filtered but that always returns NULL.

The (non-working) DAX statement I have is below:

Closed = IF(
			ISBLANK(
					CALCULATE(
								COUNTA(CombinedIncidents[IncidentNumber]),
								FILTER(CombinedIncidents,
															AND(
																CombinedIncidents[Closed Date]='Date'[Date],
																CombinedIncidents[AccountNumber] = SELECTEDVALUE(CombinedAccounts[accountnumber])															
															)
								)
					)
			),
			0,
			CALCULATE(
						COUNTA(CombinedIncidents[IncidentNumber]),
						FILTER(CombinedIncidents,
													AND(
															CombinedIncidents[Closed Date]='Date'[Date],
															CombinedIncidents[AccountNumber] = SELECTEDVALUE(CombinedAccounts[accountnumber])
														)
						)
			)
		)

Any hints would be welcome.

[Anonymous]

That's great thank you.  Turns out I was also fighting a conversion between text and numerics as well which was throwing me so my final DAX function looked like this.

Closed = IF(
			ISBLANK(
					CALCULATE(
								COUNTA(CombinedIncidents[IncidentNumber]),
								FILTER(ALL(CombinedIncidents),
															AND(
																CombinedIncidents[Closed Date]='Date'[Date],
																IF(ISNUMBER(CombinedIncidents[AccountNumber]),VALUE(CombinedIncidents[AccountNumber]),0) = VALUE(SELECTEDVALUE(CombinedAccounts[accountnumber]))															
															)
								)
					)
			),
			0,
			CALCULATE(
						COUNTA(CombinedIncidents[IncidentNumber]),
						FILTER(ALL(CombinedIncidents),
													AND(
															CombinedIncidents[Closed Date]='Date'[Date],
															IF(ISNUMBER(CombinedIncidents[AccountNumber]),VALUE(CombinedIncidents[AccountNumber]),0) = VALUE(SELECTEDVALUE(CombinedAccounts[accountnumber]))
														)
						)
			)
		)

Thanks once again for your assistance.

[TeigeGao · Accepted solution]

Hi @Anonymous ,

It is true to use the selectedvalue() function, but you need to break some original filter, we can use the ALL() function to break some original filter, for example:

FILTER(ALL(CombinedIncidents),
AND(CombinedIncidents[Closed Date]='Date'[Date],
CombinedIncidents[AccountNumber]=
SELECTEDVALUE(CombinedAccounts[accountnumber])))

Besides, we need to break the relationship between the selected field and the table CombinedIncidents.

Best Regards,

Teige