Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |