Forum Discussion
jsangerman
Helper II
Helper IIIgnore relationship in CALCULATE
I've looked through other posts on this and couldn't make any of those solutions work. So, here goes. Here's the relevant part of my model: I'm trying to calculate Active Capacity = SUM( Reso...
The bi-directional filter from Resource Allocations is what's causing Date to filter Resource. The first thing I'd recommend to do change that to a one-way filtering. That should prevent the filtering you're trying to avoid.
BTW, the reason it's not affecting Active in Date Range is because the relationship from Date to Resource To/From is inactive (plus you use ALL inside the CALCULATE functions).
jsangermanHelper II
Helper IIThat did it. And I should know better. I set it to BOTH for a different report and brought it in here.
If needed, can CROSSFILTER be used to convert a single-directional relationship to bi-directional for a specific CALCULATE formula?
AlexisOlson
Super User
Super UserYes, CROSSFILTER does that.