Forum Discussion

KNP's avatar
KNP
Super 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
bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Can you explain the the relationship between 

EMLAC[DET_NUMBER]

 

and the columns in leave summary?

 

Further more are there more columns in leave summary that aren't in your sample data.

 

I think the issue comes from the automatic context transition caused by your measure. It works fine on your first example because you're iterating over unique values. On the one that doesn't work you're iterating over a table rather than a column and don't necessarily have unique rows which causes issues when the row context moves into the filter context.

KNP's avatar
KNP
Super 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
    Community 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.