Confusion with Filter / Context

micahelw — Thu, 02 Feb 2023 21:38:34 GMT

I am confused with some results using an explicit filter rather than an implicit filter.

I have one fact table (ASB cases) and a Date table. The two tables have an active relationship between Calendar[Date] and ASB[Reported date].

I need a measure based on a Call Due date, where the call is made on time so am using USERELATIONSHIP.

I have got the measure working based on the following.

Initial Response on Time =
CALCULATE(COUNTROWS('ASB Case'),

USERELATIONSHIP('ASB Case'[Call Due to Reporting Party], 'Calendar'[Date]),

'ASB Case'[Contacted Reporting Party On Time?] = "On-Time"

)

My initial Dax which returned incorrect results was

Broken Initial Response on Time =
CALCULATE(COUNTROWS('ASB Case'),

USERELATIONSHIP('ASB Case'[Call Due to Reporting Party], 'Calendar'[Date]),

FILTER('ASB Case','ASB Case'[Contacted Reporting Party On Time?] = "On-Time"))

Clearly the way the filter is being used is wrong, but I can't really see the difference. I know Filter removes existing related filters first - so if anything was to happen I would have expected to see even more cases?

If anyone can help I'd be really grateful. I'd also welcome any advice on steps I could take to debug the issue.

Many thanks in advanve

Re: Confusion with Filter / Context

FreemanZ — Fri, 03 Feb 2023 00:09:27 GMT

hi micahelw

the syntax suger is equivalent to

FILTER(ALL('ASB Case'[Contacted Reporting Party On Time?],'ASB Case'[Contacted Reporting Party On Time?] = "On-Time"))

rather

FILTER('ASB Case','ASB Case'[Contacted Reporting Party On Time?] = "On-Time"))

without the ALL, the table is always filtered by the year/row of the matrix.

topic Re: Confusion with Filter / Context in DAX Commands and Tips

Confusion with Filter / Context

Re: Confusion with Filter / Context