Forum Discussion
Measure with Disconnected Table as Filter
TLDR
I suspect this will be easy for someone with a better understanding of DAX (currently my weakest skill set, work in progress) and that hasn't been staring at the problem for hours.
This ...
bcdobbs - DET_NUMBER is unique employee number and is not in the summary table. Yes there are more columns in the summary table (sensitive data).
Context switching hurts my brain at this time of the week. DAX context switching that is, I'd be happy to switch context to the weekend. 😂
LeaveSummaryDaysDynamic =
SUMX(
FILTER(
VALUES( LeaveSummary),
[Leave Summary Days] >= MIN(DaysGroup[MinValue])
&& [Leave Summary Days] < MAX(DaysGroup[MaxValue])
),
[Leave Summary Days]
)
Ok so as a starting point to fix it is to consider what column(s) uniquely define the set of rows you want to add up in [Leave Summary Days] inside the filter.