Choose Accounts With certain values

[Anonymous]

Hi ,

I am looking to have a visualizations that shows all the [Accounts] with a [Status] = 'NEW' at the last [Date],

The expressions I have been trying to create only keeps the last date,

I am trying see their evolution through time,

so I need them to have the value NEW at last date but I don't want the last date to be chosen, I want to see all dates,

for example what I have been doing :

count( {$<[Date] = {"$(=MaxString( TOTAL [Date]))"} , [Status] = {'New'} >} distinct [Accounts] )

or

if ( [Date] = MaxString( TOTAL [Date]) and [Status] = 'NEW'  , count( distinct [Accounts] ) )

Thank you