Forum Discussion
Apply visual level interactions without a relationship
Good morning JonPBNES
As is typical, turns out we were over thinking it. We didn't need USERELATIONSHIP, we can just read the date range selected, feed that to our filter measure and go. We do still need to compare Start Date and End Date to the date range.
OpenCaseFilter = VAR CompareStartDate = FIRSTDATE ( OpenCasesTable[Date] ) VAR CompareEndDate = LASTDATE ( OpenCasesTable[Date] ) RETURN IF ( CALCULATE ( COUNTROWS ( 'openfiltertest' ), FILTER ( openfiltertest, 'openfiltertest'[Start Date] <= CompareEndDate && 'openfiltertest'[End Date] >= CompareStartDate ) ) >= 1, "In", "Out" )You can see the result we want even after I deleted the link between the two tables.
Of course, I re-keyed my count measure wrong didn't I. What an eejit!
The issue still seems to be persisting into the drillthrough measure, however.
Good morning JonPBNES
As is typical, turns out we were over thinking it. We didn't need USERELATIONSHIP, we can just read the date range selected, feed that to our filter measure and go. We do still need to compare Start Date and End Date to the date range.
OpenCaseFilter =
VAR CompareStartDate = FIRSTDATE ( OpenCasesTable[Date] )
VAR CompareEndDate = LASTDATE ( OpenCasesTable[Date] )
RETURN
IF (
CALCULATE (
COUNTROWS ( 'openfiltertest' ),
FILTER (
openfiltertest,
'openfiltertest'[Start Date] <= CompareEndDate
&& 'openfiltertest'[End Date] >= CompareStartDate
)
) >= 1,
"In",
"Out"
)You can see the result we want even after I deleted the link between the two tables.
That's cracked it! Thank you so much for your time.
We don't use VAR anywhere near enough, I'm realising. (there's probably a world cup joke in there somewhere)