Forum Discussion

Regular Visitor

9 years ago

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?

Solution Supplier

9 years ago

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 ...

Regular Visitor

9 years ago

Actually I don't need to calculate any table, so I can get by with thise:

SUMX(

FILTER(table1;table1[date]<=MIN(dates_min[date]))

;table1[A])

Thank you very much

Cheers