Today() function DAX unfiltering my visual table

Hi,    I have a table in my report that summerises a runing stock total.    I use a measure that find the lastest date which the stock levels fall below 0 - per material.    This all works fine...