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

     

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
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] )
    )
)

 

jankooy's avatar
jankooy
New Member
5 months ago

Thank you.  This works.  Tried "KEEPFILTERS" but that did not work.  "ALLSELECTED" does.