Forum Discussion

jp2020's avatar
jp2020
Helper I
5 years ago
Solved

Cumulative Running Total Issue with Legend

Hi all,   I have a cumulative column working using quick measure:   Cumulative Amount= CALCULATE ( SUM('Table'[Amount] ), FILTER (ALLSELECTED('Table'), 'Table'[ORDER_DATE] <= MAX( 'Table'[ORD...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    jp2020 , Try if this can help

    Cumulative Amount= CALCULATE (
    SUM('Table'[Amount] ),
    FILTER (ALLSELECTED('Table'),'NT Transactions'[Client_Type] =max('NT Transactions'[Client_Type] ) &&
    'NT Transactions'[ORDER_DATE] <= MAX( 'NT Transactions'[ORDER_DATE] )
    )
    )

amitchandak's avatar
amitchandak
Super User
5 years ago

jp2020 , Try if this can help

Cumulative Amount= CALCULATE (
SUM('Table'[Amount] ),
FILTER (ALLSELECTED('Table'),'NT Transactions'[Client_Type] =max('NT Transactions'[Client_Type] ) &&
'NT Transactions'[ORDER_DATE] <= MAX( 'NT Transactions'[ORDER_DATE] )
)
)

  • jp2020's avatar
    jp2020
    Helper I
    5 years ago

    That worked perfectly, thank you!

  • Elvi_well's avatar
    Elvi_well
    Frequent Visitor
    1 year ago

    Hi!
    I tried this and it works! Thanks! But I have met another problem. If client C does not have any order in MAR I would like that it shows me the number from the previous month (like 4+0=4), but client C does not appear at all. Is it some way to do it like this? All clients are showen every month with result to this month.