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

     

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

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

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