Forum Discussion

jankooy's avatar
jankooy
New Member
5 months ago
Solved

Cumulative total more than current value using current filters

I am working on a survival analysis for a large list of assets.  I want to use the current filters to update the analysis.  I need to have a cumulative total for the assets that calculates the total ...
  • cengizhanarslan's avatar
    cengizhanarslan
    5 months ago

    I am not exactly sure what you ask but I far as I understand this could help:

    Cumulative Total =
COUNTROWS (
    FILTER (
        ALLSELECTED ( 'ASSET' ),
        'ASSET'[Calc_Age] <= MAX ( 'ASSET'[Calc_Age] )
    )
)

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 months ago

jankooy are you saying you need a cumulative total by each asset? Sorry, your question is not clear. Can you add more rows of the same asset and provide the expected output? The current sample data and output is hard to understand what exactly you are looking for.