Forum Discussion

ChrisWeeks92's avatar
ChrisWeeks92
Helper I
7 years ago

live dataset issues for floorplan

Hi

 

I am trying to create a synoptic panel floor plan looking like this 

My aim is to show the live status of the doors & windows.  It isnt quite working though.  It isnt pulling the latest row through to the panel.  

My data looks something like this;

 

The closed column is a measure with the following DAX

closed = IF(CONTAINS(RealTimeData,RealTimeData[state],"NOT_PRESENT"),0,1)

and Last Closed State is another measure which isnt working correctly though.  This has the following DAX

LastClosedState = 
IF ( 
    HASONEVALUE ( RealTimeData[area2]),
    VAR LastTime = MAXA(RealTimeData[createTime])
    VAR Result = CALCULATE (RealTimeData[closed] , RealTimeData[createTime] = LastTime )
    RETURN Result
)

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. 

Need Help

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi ChrisWeeks92,

     

    For further analysis, could you share your connection string or rest api connection details in your power query code? 

     

    Regards,

    Jimmy Tao

    • ChrisWeeks92's avatar
      ChrisWeeks92
      Helper I
      7 years ago

      Hi v-yuta-msft  

       

      My JSON connection is this

       

      {
    "type": "object",
    "properties": {
        "event": {
            "type": "object",
            "properties": {
                "eventId": {
                    "type": "string"
                },
                "targetName": {
                    "type": "string"
                },
                "eventType": {
                    "type": "string"
                },
                "data": {
                    "type": "object",
                    "properties": {
                        "temperature": {
                            "type": "object",
                            "properties": {
                                "value": {
                                    "type": "integer"
                                },
                                "updateTime": {
                                    "type": "string"
                                }
                            }
                        },
                        "touch": {
                            "type": "object",
                            "properties": {
                                "updateTime": {
                                    "type": "string"
                                }
                            }
                        },
                        "objectPresent": {
                            "type": "object",
                            "properties": {
                                "state": {
                                    "type": "string"
                                },
                                "updateTime": {
                                    "type": "string"
                                }
                            }
                        }
                    }
                },
                "timestamp": {
                    "type": "string"
                }
            }
        },
        "labels": {
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "area": {
                    "type": "string"
                },
                "area2": {
                    "type": "string"
                }
            }
        }
    }
}

      and the data is being pushed to the flow url which is then being added into the live Power BI dataset

       

      Does this help?

      • ChrisWeeks92's avatar
        ChrisWeeks92
        Helper I
        7 years ago

        Sorry to post again, but can anyone help me as i need to get this over to my boss by monday.  

         

        Ultimately i am after the latest row only from each area2 and the status of whether they are open or not.  

         

        I am using api/live data so i can only create measures.  

         

        Any help is much appreciated