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

 

 

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

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Super 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
        Super 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] )
        )
        )

  • Anonymous's avatar
    Anonymous
    Not applicable
    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])
    )
    )