I have a main tanle whcihc has a VC that shows the last delivery date for an outlet/row in that main table that is taken from the “Orders” table.
MAX ( SELECT(Orders[Delivery Date], [Outlet No] = [_THISROW].[Outlet No]))
I would also only like to only show orders that have a [Order Total Inc Vat] column in the “Orders” table greatr than 0.
I can’t work out where to ass in the AND() expression.