Trying to get latest value per location - measure

[slendin]

I hope you guys can help me with this measure, since iam not a PowerBi god :).

What im trying to do is show the latest temperature by location so i can use the latest temperature value in power bi visuals.

Here is an exampe of my sql table: temperature_events

timestamp                   temperature          locatie

26-8-2019 12:23:21     19.2                        Hall

26-8-2019 12:21:47     19.9                        Room 1

26-8-2019 12:19:41     20.1                        Hall

26-8-2019 12:16:22     21.1                        Room 2

26-8-2019 12:15:12     19.0                        Room 1

26-8-2019 12:12:10     22.9                        Room 2

I tried the following measure, but i get # the expression refers to multible columns. Multible columns cannot be converted to scalar value.

CategoriesLatest = SUMMARIZE(temperature_events;temperature_events[locatie];"timestamp";MAX(temperature_events[datetime]);"temperature";CALCULATE(SUM(temperature_events[temperature]);FILTER(temperature_events;temperature_events[datetime]=MAX(temperature_events[timestamp]))))

[MatejZukovic]

Hi @slendin ,

aggregating data in your visual based on last timestamp should do the trick!

[AlB · Accepted solution]

Hi @slendin

You can place Table1[locatie] in the visual and then: 

Measure =
VAR Latest_ =
    CALCULATE ( MAX ( Table1[timestamp] ) )
VAR LatestTemp_ =
    CALCULATE ( DISTINCT ( Table1[temperature] ), Table1[timestamp] = Latest_ )
RETURN
    LatestTemp_

Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

Cheers  

[slendin]

Awesome, worked like a charm! Thanks!