EARLIER function not working with MAX of a group

[SSS]

Good Morning

I am struggling with the Earlier function as I am not able to make it work.

I have a column called ID, another called DATE and another called TIME

as an example:

ID           DATE           TIME
1            1/1/2018          5
2            1/1/2018          1
3            1/1/2018          3
1            2/1/2018          6
2            2/1/2018          2
3            2/1/2018          4
...

As you can see I have the date, and the time that is taken for ID nº X to finish.

I want to calculate a measure that tells me the Maximum time that takes for the ID to be finished, in this case for ID 1 it would be 6 as an example.

THe formula that I have used is the following one:

Medida = calculate(MAX(Table1[TIME]; FILTER(Table1; Table1[ID] = Earlier(Table1[ID]))

But I am not able to make it work as it tells me that there is an error in the Measure.

Can anyone help me in order to accomplish this task? Thanks a lot.

[Zubair_Muhammad · Accepted solution]

Hi

Please try replacing earlier with selectedvalue