Forum Discussion

Khomotjo's avatar
Khomotjo
Helper II
1 year ago

Filter(ALL not working

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
Need Help

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    1 year ago

    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's avatar
        Khomotjo
        Helper II
        1 year ago

        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 :