Forum Discussion
Solved
Does function FILTER() work with another function given as a parameter?
Hi, I’m trying to calculate table B from filtered table A (the filter condition is a cutting date): Does anyone know what I'm doing wrong in case B?
In your file Table3 is a calculated table ...
Calculated tables are static parts of a model : their content will not change based on selections or slicers.
You can use table expressions in measures to obtain dynamic selections, though ...
This may be related to: http://www.sqlbi.com/articles/usage-of-dates-argument-in-a-row-context/
The short explanation is: FIRSTDATE has an implicit CALCULATE and is evaluated depending on the row context of TableA.
If correct, your condition probably evaluates to TRUE for each row.
Try with the MIN function instead.