Forum Discussion
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(Stoc...
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?
Hello Vanessa, this is a direct query
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 :
what are you trying to do, convert the date to a date?
