Forum Discussion

JulietteGSA's avatar
JulietteGSA
Frequent Visitor
8 years ago
Solved

Cumulative Total - Changing start date

Hi everyone, I have a problem with my cumulative totals : I have been able to create measures that calculate cumulative totals but it does not adapt to my dashboard filters.   This is what I wrote...
  • Anonymous's avatar
    Anonymous
    8 years ago

    have you tried using just ALL instead of ALLSELECTED in your first measure as that may be causing issues.

     

    In_Full_Agg =
IF (
    AND (
        MIN ( 'Date'[Date] )
            <= CALCULATE ( MAX ( 'Cube OTIF'[Date] ); ALLSELECTED ( 'Cube OTIF' ) );
        MAX ( 'Date'[Date] ) >= CALCULATE ( MIN ( 'Cube OTIF'[Date] ) )
    );
    CALCULATE (
        SUM ( 'Cube OTIF'[Nb Orders In Full - SI] );
        FILTER ( ALL ( 'Date'[Date] ); 'Date'[Date] <= MAX ( 'Date'[Date] ) )
    )
)
v_ichharam's avatar
v_ichharam
Frequent Visitor
4 years ago

Using "all" allows me to keep history in the calculation even when filtering out periods