Forum Discussion

bboy81905's avatar
bboy81905
Frequent Visitor
8 years ago

Filter MAX date is not working in Directquery mode

Hi everyone : 

My report needs to present the latest value, so I try below formula :

LatestTurbidity = CALCULATE(MAX(MsgJamhamTest1[Value]), FILTER(MsgJamhamTest1,[Type]="Turbidity"&&[UpdateTime]=MAX([UpdateTime])))

But it's not working, always return blank value in Directquery mode. In import mode, this formula is working!  What's the problem?

I have click Allow unrestricted measure in Directquery mode

Need Help

4 Replies

    • bboy81905's avatar
      bboy81905
      Frequent Visitor
      8 years ago

      Thank your response!
      But If I group by UpdateTime to 1min, and use this column(MinutesTime), it's working. But sometimes also returned blank! I think this Formula is working in Directquery mode.  It's an issue in Power-BI ?

      LatestTurbidity = CALCULATE(MAX(MsgJamhamTest1[Value]), FILTER(MsgJamhamTest1,[Type]="Turbidity"&&[MinutesTime]=MAX([MinutesTime])))

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI bboy81905,

         

        I think it may related refresh interval, maybe you can try to increase your filter range to get more records.(direct query live connect but I think it still has update interval)

         

        Regards,

        Xiaoxin Sheng