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

     

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

You can use 

Cumulative Total =
VAR MaxAge =
    MAX ( ASSET[Calc_Age] )
VAR Result =
    CALCULATE ( COUNTROWS ( ASSET ), ASSET[Calc_Age] <= MaxAge )
RETURN
    Result

This will keep any filters already in place but replace the filter on Calc_Age, coming from the visual.

If the calc age happens to be sorted by a different column then you would also need to remove the filters from the sort by column, e.g.

Cumulative Total =
VAR MaxAge =
    MAX ( ASSET[Calc_Age] )
VAR Result =
    CALCULATE (
        COUNTROWS ( ASSET ),
        ASSET[Calc_Age] <= MaxAge,
        REMOVEFILTERS ( ASSET[Sort by column] )
    )
RETURN
    Result