Running Total - Not Showing Cumulative Amount

[Qotsa]

Hi,

Any idea why this isn't showing the cumulative total but rather the grand total. Must be related to the date.

Running Total Hrs =
CALCULATE (
SUM ( 'powerbi114 view_finance'[Hrs] ),
FILTER (
ALL ( 'powerbi114 view_finance' ),
'powerbi114 view_finance'[carer_id]
= EARLIER ( 'powerbi114 view_finance'[carer_id] )
&& 'powerbi114 view_finance'[date] <= MAX ( 'powerbi114 view_finance'[date] )
)
)

[Qotsa · Accepted solution]

This is what worked for me.

Running Tot =

CALCULATE(

[Total Hrs]

, FILTER( ALL( 'powerbi114 view_finance' )

, 'powerbi114 view_finance'[carer_id] = MAX('powerbi114 view_finance'[carer_id])

&& 'powerbi114 view_finance'[Sched_Start] <= MAX( 'powerbi114 view_finance'[Sched_Finish] )

&& 'powerbi114 view_finance'[date] = MAX('powerbi114 view_finance'[date])

)

)

[Qotsa]

@amitchandak Still no luck with that. Here's the file - Sample PBX 

[amitchandak]

@Qotsa , Try a measure like

Running Total Hrs =
CALCULATE (
SUM ( 'powerbi114 view_finance'[Hrs] ),
FILTER (
ALL ( 'powerbi114 view_finance' ),
'powerbi114 view_finance'[carer_id]
= EARLIERall( 'powerbi114 view_finance'[carer_id] )
&& 'powerbi114 view_finance'[date] <= MAX ( 'powerbi114 view_finance'[date] )
)
)

or

Running Total Hrs =
CALCULATE (
SUM ( 'powerbi114 view_finance'[Hrs] ),
FILTER (
ALLselected ( 'powerbi114 view_finance' ),
'powerbi114 view_finance'[carer_id]
= EARLIERall( 'powerbi114 view_finance'[carer_id] )
&& 'powerbi114 view_finance'[date] <= MAX ( 'powerbi114 view_finance'[date] )
)
)

[Qotsa]

@amitchandak Thks for that. Prob with the Earlierall

[amitchandak]

@Qotsa , Sorry, Try these

Running Total Hrs =
CALCULATE (
SUM ( 'powerbi114 view_finance'[Hrs] ),
FILTER (
ALL ( 'powerbi114 view_finance' ),
'powerbi114 view_finance'[carer_id]
= max( 'powerbi114 view_finance'[carer_id] )
&& 'powerbi114 view_finance'[date] <= MAX ( 'powerbi114 view_finance'[date] )
)
)

or

Running Total Hrs =
CALCULATE (
SUM ( 'powerbi114 view_finance'[Hrs] ),
FILTER (
ALLselected ( 'powerbi114 view_finance' ),
'powerbi114 view_finance'[carer_id]
= max( 'powerbi114 view_finance'[carer_id] )
&& 'powerbi114 view_finance'[date] <= MAX ( 'powerbi114 view_finance'[date] )
)
)