Showing only the latest observation for two combined values

[BrianEh]

I am trying to set a simple table that has values that can change.

I easily have it showing this:

What I am trying to do is only show the two rows where the date measure is the MAX. 

Basically, I am looking to do a table that only shows the latest observation for a Cart at a Room.

And I can't wrap my brain around how to do that.

[jbocachica]

Hi, when you said 2 rows, why is that?, based on your post, you must have just 1 row (The last observation is just 1 observation), please clarify that to help you.

Regards

[BrianEh]

I am trying to have one row for 'blueberry' and one row for 'minty' each having a unique last observed datetime.

thus 2 rows (one for each cart).

[jbocachica]

Hi, you can use this expression in a new column

Its Max = if(YourTable[Measure] = calculate(max(YourTable[Measure]), filter(YourTable,YourTable[cart] = EARLIER(YourTable[cart]))), "Show", "No Show")

Just create a filter based in the new column

Regards

[Vvelarde]

@BrianEh

Try with RankX

Ranking = RANKX(ALLEXCEPT(Table1,Table1[cart]),[measure],,DESC)

In Visual Level Filter Select 

Ranking is 1.