Slicing a Runningtotal by hour with other filters

[Anonymous]

Hello, I have a runningtotal measure that sums the number of appplications to each hour, per day. 

RunningTotal =

CALCULATE(

SUM('FLA'[ApplicationCount])

,FILTER(

ALLSELECTED(FLA),

FLA[Time] <= MAX(FLA[Time])

&& FLA[Date] = MAX(FLA[Date])

)

)

This measure accurately filters by state and weekday but not by time. 
For instance when the line graph is filtered by state (CA): 

You can see that the runningtotal value for CA when hovered at 12/3/21 7:00PM is 2,179. 

However, when 7:00PM is selected for my time slicer: 

There is an incorrect value of 154 for CA on 12/3/21. 

The X axis of my line graph is: 

AppHourEst =

VAR a =

SELECTEDVALUE(FLA[Time])

RETURN

IF ( a = FLA[Current_Hour_Flag], FLA[ApplicationHourEST], a)

The Value of my line graph is the runningtotal measure, mentioned above. 

My time slicer value is: 

Time = TIMEVALUE(FLA[ApplicationHourEST])

I do not understand why my line graph is filtering down incorrecting by the hour, so any help would be greatly appreciated. 

All of the data is from one table, FLA and the sample data can be found here: 

https://docs.google.com/spreadsheets/d/1Ddmx0vcP7t4J1W3l4YgnxYAlXK7ZtRDJ/edit#gid=1127929229

Thanks, 

Aaron

[amitchandak]

@Anonymous , based on what I got.

Create a new date time column and use that

Date time = FLA[Date] + FLA[Time]

RunningTotal =
CALCULATE(
SUM('FLA'[ApplicationCount])
,FILTER(
ALLSELECTED(FLA),
FLA[Date time] <= MAX(FLA[Date time])
)
)

This should work to reset cumulative daily

RunningTotal =
CALCULATE(
SUM('FLA'[ApplicationCount])
,FILTER(
ALLSELECTED(FLA),
FLA[Time] <= MAX(FLA[Time])
&& FLA[Date] = MAX(FLA[Date])
)
)

[Anonymous]

Hi @amitchandak, unfortunately that new runningtotal measure seems to be summing up too much. Also it doesn't accurately return the correct value for my test case; filtered to CA and 7:00pm.

Thanks for your suggestion, I'll try to experiment more with that idea.