Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |