Table with first day of year and current day

[Juan_Lu]

Hi everyone,

I have a requirement from my client to compare in the same table data from  a date selected from slicer and the first day of the year. I can't get correct data.

Sample data:

date_load	ID
01/01/2017	ID1
01/01/2017	ID2
01/01/2017	ID3
01/01/2017	ID4
01/06/2017	ID1
01/06/2017	ID2
01/06/2017	ID3
01/09/2017	ID1
01/09/2017	ID2
31/12/2017	ID1
01/01/2018	ID1
01/01/2018	ID7

and two measures:

Start Year = CALCULATE(COUNTROWS(Table1);FILTER(Table1;Year(SELECTEDVALUE(Table1[date_load])) = YEar(Table1[date_load])))

Current = COUNTROWS(Table1)

I need to show for 1/1/2017

Start Year = 4

Current =4

and for 31/12/2017

Start Year = 4

Current =1

but get 

Start Year = 1

Current =1

Thank you in advance

[Zubair_Muhammad · Accepted solution]

@Juan_Lu

Try this MEASURE

Start Year =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER (
        ALL ( Table1 ),
        Table1[date_load] = DATE ( YEAR ( SELECTEDVALUE ( Table1[date_load] ) ), 1, 1 )
    )
)