Forum Discussion

KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

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 ...
Need Help
KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

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. ğŸ˜‚

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago
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.