Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Running Total - Not Showing Cumulative Amount

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] ), FIL...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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])
    )
    )

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak Thks for that. Prob with the Earlierall

 

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

Anonymous , 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] )
)
)