Count First Occurrences of Value

[Micki]

Hi folks, below my simple table 

Table1.Date	Table2.Field	New Defects	firstsortedvalue(Date,Date])
20200120	New	1	2020-01-20
20200127	New	1	2020-01-27
20200203	New	1	2020-02-03
20200210	New	1	2020-02-10
20200217	New	1	2020-02-17
20200224	New	1	2020-02-24

Please Notice that i have two fields from different table and i need just to count first appearances

What i did:

COUNT({
[FLAG_NEW] = {'New'},
[Date] = {"=firstsortedvalue(floor([Date]), floor([Date]))"}
					>}DISTINCT [%WorkItem])


//Option 2
count(Aggr(
  If(FirstSortedValue(Date_FLoor, -Date_FLoor) = Floor_CreatedDate, 1, 0)
, [%WorkItem]))

Still doesn't work 😞

Second Option is working but when i select specific bar it's stop working because i used aggr() 

Expected result 

Table1.Date	Table2.Field	New Defects	firstsortedvalue(Date,Date])
20200120	New	1	2020-01-20
20200127	New		2020-01-27
20200203	New		2020-02-03
20200210	New		2020-02-10
20200217	New		2020-02-17
20200224	New		2020-02-24

[Kushal_Chawda]

@Micki  what is the dimension of Bar? Try adding that Dimension as well in aggr