Forum Discussion

copzyz123's avatar
copzyz123
Microsoft Employee
5 years ago
Solved

How to create summary table for a Push Dataset?

Greetings.   I have created a power bi streaming api push dataset, and I have a job keep sending data to push dataset api every minute. The schema is something like: {      IncidentId: Text,    ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, copzyz123 

     

    It’s my pleasure to answer for you.

    According to your description, I think you can make some modifications in the table format, and create measures to get the latest status and count the number of process.

    Like this:

     

     

     

     

     

     

     

     

     

     

     

     

    Measure:

     

    latest status =
LASTNONBLANKVALUE (
    pushdateset[UpdatedDate],
    SELECTEDVALUE ( pushdateset[State] )
)
    Created =
COALESCE (
    COUNTROWS (
        FILTER (
            SUMMARIZE ( pushdateset, pushdateset[IncidentId] ),
            [latest status] = "Created"
        )
    ),
    0
)

     

     

    If you have other questions, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, copzyz123 

 

It’s my pleasure to answer for you.

According to your description, I think you can make some modifications in the table format, and create measures to get the latest status and count the number of process.

Like this:

 

 

 

 

 

 

 

 

 

 

 

 

Measure:

 

latest status =
LASTNONBLANKVALUE (
    pushdateset[UpdatedDate],
    SELECTEDVALUE ( pushdateset[State] )
)
Created =
COALESCE (
    COUNTROWS (
        FILTER (
            SUMMARIZE ( pushdateset, pushdateset[IncidentId] ),
            [latest status] = "Created"
        )
    ),
    0
)

 

 

If you have other questions, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.