Forum Discussion

jp2020's avatar
jp2020
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper I rankHelper I
5 years ago

That worked perfectly, thank you!