Forum Discussion

khush19's avatar
khush19
Icon for Resolver I rankResolver I
5 years ago

Filter on datetime column sometime work ,sometime not

I am working on report ,where i need to take the amount based on latest datetime. For this i created a measure Total Calculated Amount = CALCULATE(sum(ParkingSessionSA[TotalAmount]),FILTER(Parking...
Need Help
khush19's avatar
khush19
Icon for Resolver I rankResolver I
5 years ago

HI Greg,

 

I have data like :

now i need to get Amount based on max (currenttime).

For this i created a measure and this measure is used in many measure to calculate difference ,% change.

and the worst part is it,this measure works sometimes and sometimes not.

and it work in SIT,UAT and fail only in PROD 😞

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

khush19 , You expected output is not clear. Max on the row context as good as row values unless there is some logic added

Try

Total Calculated Amount =
var _max =MAXX(ParkingSessionSA,ParkingSessionSA[CurrentTime])
return
CALCULATE(sum(ParkingSessionSA[TotalAmount]),FILTER(ParkingSessionSA,ParkingSessionSA[CurrentTime]=_max))

 

Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.

  • khush19's avatar
    khush19
    Icon for Resolver I rankResolver I
    5 years ago

    HI Amit,

     

    I tried the measure you suggested,even that is also not working.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      5 years ago

      khush19 OK, has to be an issue with your data then. Is this import mode or Direct Query mode or?

      • khush19's avatar
        khush19
        Icon for Resolver I rankResolver I
        5 years ago

        This is PUSH dataset ,where data is pushed to power BI every 5 mins from Azure data factory