Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
7 years ago
Solved

Streaming Dataset - Measures

Hi All,

 

We have managed to set up a streaming dataset that is driven via a Powershell script which pulls data from our SQLServer DB. Everything is working well apart from some really stange behaviour when trying to create measures, does anyone know if there are any known limitations when working in this way?

 

One measure we have tried is:

 

CALCULATE (
    [Total],
    FILTER (
        ALL ( RealTimeData[timestamp] ),
       RealTimeData[timestamp] = MAX ( ( RealTimeData[timestamp] ) )
    )
)
RealTimeData[timestamp] is a datetime field
 
This has worked in other reports but not with the streaming datset. We have also noticed that trying to use a top N filter also behaves strangely.
 
I have searched online but the documentation (that I have found) is not very clear 
 
Any thoughts appreciated

5 Replies