measure - get last date

[stefan321]

I have the following table:

Like to have a measure where i get the last "Online" (see Status column) date (Column Time) from each Server. 
Example:

Server A --> 19 Mar 2024 14:50:11
Server B --> 6 Mar 2024 15:50:14

It would be also nice when i can filter for that last online date with a measure field

[sjoerdvn]

There is obviously more going in your model & report, cannot help you with what info you provided so far.

[sjoerdvn]

Try something like below. Adjust for your table name, Also adjust if Status or Time have relationships with other tables (dimensions)

Last Online Time = CALCULATE(MAX('table'[Time]),ALL('table'[Time]),'table'[Status]="Online")

[stefan321]

HI 
unfortunately it do not work.
Now i get only "Online" results, but i want to see in Table all other Status results as well, for example also"Offline"
Additionaly "Last Online Time" show wrong Time (compared to Time column )
In that example it should show for Server "geus" 28.11.2023 14:27:50

Is it possible to fitler that measure only for the last online Time?