and Last Closed State is another measure which isnt working correctly though. This has the following DAX
HASONEVALUE ( RealTimeData[area2]),
VAR LastTime = MAXA(RealTimeData[createTime])
VAR Result = CALCULATE (RealTimeData[closed] , RealTimeData[createTime] = LastTime )
My dataset is being inserted from MS-Flow via an API. when a door or window opens or closes it inserts another row with the current status and this is what i want the synoptic panel visual to view and not the previous rows in the dataset.
I have a deadline for this friday to get it working and for the panel to be updating when someone opens/closes the window or door. I hope someone is able to guide me in the right direction and get the floorplan working correctly.