Forum Discussion
Khomotjo
Helper II
1 year agoFilter(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...
Khomotjo
Helper II
1 year agoHello 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
Community Champion
1 year agowhat are you trying to do, convert the date to a date?