Forum Discussion
Measure with Disconnected Table as Filter
The Syntax for values is we need to use either table name Or column name.
VALUES ( TableNameOrColumnName)
In your DAX you must use the column as
VALUES(LeaveSummary
[GNA_ORG_NAME])
Please use the below function and try.
LeaveSummaryDaysDynamic =
SUMX(
FILTER(
VALUES(LeaveSummary
[GNA_ORG_NAME]),
[Leave Summary Days] >= MIN(DaysGroup[MinValue])
&& [Leave Summary Days] < MAX(DaysGroup[MaxValue])
),
[Leave Summary Days]
)
Please mark it as solved If it works.
Unfortunately that doesn't help.
This is the incorrect data currently...
This is with your suggested modification...
Should match the LeaveDaysDynamic column as there are no filters applied.
Any other ideas?
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.
