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

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?

 

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