Filter(ALL not working

[Khomotjo]

Hello everyone, 

I have this measure :

Picked_Orders = CALCULATE(

DISTINCTCOUNT(StockMovements[Reference]),

FILTER(ALL(StockMovements),

TRUNC(StockMovements[Finalised_Date]) = TRUNC(MAX(StockMovements[Required_Date]))

)

)

I get this error when refreshhing the data:

My source is a table I extracted from a database. I noticed that the filter function works well with the data but the moment I try to filter(ALL I get an OLE DB or DBC error

[vanessafvg]

please provide a screenshot of the with the exact message, when does the error happening on refreshing

is this an imported model or direct query?

[Khomotjo]

Hello Vanessa, this is a direct query

[Khomotjo]

Hello Vanessa, I think I figured out what the issue is although I do not have the solution. I brought TRUNC(FinalisedDate) as a column and got this error : 

[vanessafvg]

what are you trying to do, convert the date to a date?