Forum Discussion

Nickgastaldi's avatar
Nickgastaldi
Resolver I
7 years ago

Unexpected? filter behavior when translating to TSQL

Hello Comunity,    long time following, first time posting,  I am not sure if i lack the necessary knowledge but i am facing what i consider a strange behaviour in one of my dashboards, here is t...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I am not sure if this will work but you can try

ids last hour = 
VAR LastStamp = MAX( myTable [timestamp] ) - (1/24) -- last update minus 1 hour. (this works fine)
VAR tbl = FILTER( myTable, myTable [timeStamp] > LastStamp)

Return
COUNTROWS(
  SUMMERIZE(
    tbl,
    myTable[Id]
  )
)
Nickgastaldi's avatar
Nickgastaldi
Resolver I
7 years ago

Hello Kristjan76

thanks for your reply

 

i did tried that , but exact same result, 

for what i can see comparing PBI execution and DB log, the problem is not in the calculation itself but in the FILTER statement, its returning the exact same TSQL as i posted in question and no where clause is applied. 

 

the calculation is not even sent to DB