Filter on datetime column sometime work ,sometime not

Question

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(ParkingSessionSA,ParkingSessionSA[CurrentTime]=MAX(ParkingSessionSA[CurrentTime])))

Somethimes measure show value ,sometimes not,not able to figure out why

greg_deckler · Answer

khush19&nbsp;Betting there is probably a reason. Unfortunately, not really enough information to go on. What exactly are you trying to accomplish with that measure because it seems like it could just be:
sum(ParkingSessionSA[TotalAmount])
&nbsp;
Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

khush19 · Answer

HI Greg,&nbsp;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 · Answer

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))
&nbsp;
Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.

greg_deckler · Answer

khush19&nbsp;First, not typing that data into an Enter Data query to mock this up, please post as text.
&nbsp;
Second, what do you mean by the MAX of currenttime? If you have a measure and you put it in a visual along with currenttime column then if you get the MAX of the currenttime, you are getting that row's currenttime, which is already in context so you don't need to filter on it because that row in the table visualization and already filtered to that currenttime which is why your formula seems like it is equivalent to SUM([totalamount])
&nbsp;
In other words, if I had data like:
&nbsp;
Color
Red
Orange
Blue
&nbsp;
And I create a measure like:
Measure = MAX([Color])
&nbsp;
This would return the exact same thing as:
Measure = CALCULATE(MAX([Color]),FILTER('Table',[Color]=MAX([Color])))
&nbsp;
So, should your measure work? Yes, but it is unnecessarily complicated.
&nbsp;