Forum Discussion
Confusion with Filter / Context
Hi
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.
CALCULATE(COUNTROWS('ASB Case'),
CALCULATE(COUNTROWS('ASB Case'),
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
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.
1 Reply
- FreemanZSuper User
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.